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

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

Other recent topics Other recent topics