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.