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.
View Complete Post