SSIS variable not populating
Fellow code grinders,
I have created dozens of data loads using VS2005 and several using VS2008 using the Foreach Loop Container.
So I post this as a moderate SSIS developer:
My Execute SQL Task, which only returns one column, works and populates a variable, ManifestResults (which is a system.object), without an issue (I THINK).
I then use the variable, ManifestResults, to set my Foreach Loop Container’s ADO object source variable.
I then set my variable, manif_nbr (which is a string) with the index of 0 in the Foreach Loop Container.
I then set breakpoint to confirm that the variable, manif_nbr, has changed… which it doesn’t.
I am stumped.
I can only think of 1 thing –
The system.object variable really isn’t being populated from the query (which I have: double checked the connection, copied and pasted the query in SMSS and query was executed successfully).
How do I prove that the system.object variable, ManifestResults, has something in it?
Is there something else may have been messed up (like metadata) during my development?
Any suggestions?
February 11th, 2011 8:51am