Unable to analyze SSIS data flow OLE DB sources using SQL-command from variable

Oct 30, 2014 at 11:42 AM
Hi, when the OLE DB source in data flow of an SSIS 2008 package uses a variable that includes the defined SQL command, I always get the following error message when running analysis:

Error occurred: 'The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.

_Any idea why or is there a limit of the toolkit?

thx