Click here to Skip to main content
15,888,600 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi I have a SSIS job. While I run it, it will return me the error message as the title above. I have checked the variables that should have passed into the FOREACH loop and they are no empty as there are data return from SQL whenever I execute the SQL statement in my DB. As I cant find the option for me to upload my screen shot, therefore I will describe my error as detailed as possible:

Execute SQL Task --> Foreach Loop

Inside the loop it contains 3 variables, namely: varNumberFamilyItem, varSupplierCode and varNeedFTP with index 0, 1, 2 respectively. They are all under Variable Mappings.

Whereas inside my Collection, I have chosen ADO object source variable as User::Object and Enumeration Mode as "Rows in the first table". I have not configure any Expressions to overwrite the data returned.

But whenever I run my SSIS job, it will stop at Foreach loop and display the error message as the title above. Any help would be appreciated.

FYI, I have put my tasks inside Control Flow.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900