Issue in using the variable in SSIS

Asked By steve.john 0 points N/A Posted on - 06/27/2011

Hi all,

It is a dynamic process in SSIS. I have designed an SSIS package, where it picks up flat files dynamically from a directory and it dumps those source data into the dynamic SQL tables. I passed the SQL table names as variables in the OLEDB destination component. But it was showing the error “task cannot find the target SQL table” something. It is not the exact error message. How can I resolve this issue?

Thank you.

• Status: Open
• Question Views: 892
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By sophia.emma24 10 points N/A #129168

Issue in using the variable in SSIS

You are trying to pass the run time variable that has to be validated with some delay. It means that the value of the variable should be changed according to the source file. This can be achieved by doing a simple change in the properties.

Click on the OLEDB Destination component, you can see it’s properties in the right pane of the SSIS environment. Then locate the “Delay Validation“ property in that pane and set as “true”. Now execute the package, the variables will be changed according to the first previous tasks.

Actually, before the execution, SSIS will validate all the variables during the pre-compilation. The compiled variable’s value will not changed at the run time until purposely changing it’s value between the process. So, to switch off this feature, you have to set the Delay Validation property as true. You can use this concept in mostly all the tasks in SSIS. But, don’t set it as true at all instants, it may create problem for the variables during the run time.

About sophia.emma24

Questions
1

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/27/2011
• Question Category: MS SQL Server