OLED DB data source not seeing variable with scope of containing sequence container
I'm using SQL Server 2008 R2. I have a sequence container in which an execute SQL task assigns a value to a variable, the last task in the sequence container is a data flow task with a single OLEDB source (SQL Server 2000) and destination. The source in the data flow uses the variable which has the scope of sequence container, however when the query in the data flow task source is executed, its as if its seeing a null value for the variable, can someone please advise as to what I'm doing wrong here.
April 14th, 2011 6:01am

Can you verify that execute SQL task Actually assigned a value to the variable?
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 6:09am

Also check if variable is of proper data type.
April 14th, 2011 6:14am

Breakpoints can be used to check whether the variable value is actually fetched correctly(basically debugging). When the scope of the variable is with sequence container the scope should reach even the tasks inside the sequence container. Put a break in the post execute of execute sql task and check the locals in debug menu.Regards and good Wishes, Deepak.
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 6:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics