ForEach Loop container issue!!!

Hi everyone,

I am having hard time with foreach loop container. The for each loop container in my package goes over all the rows in a ADO enumerator recordset variable and shows row values one by one in message box. The problem is that it just keeps printing the first row infinitely. Could anyone tell me what could be wrong?

Thanks in Advance,

Care to share the code on how you build the message box?|||

Praveen Dayanithi wrote:

Hi everyone,

I am having hard time with foreach loop container. The for each loop container in my package goes over all the rows in a ADO enumerator recordset variable and shows row values one by one in message box. The problem is that it just keeps printing the first row infinitely. Could anyone tell me what could be wrong?

Thanks in Advance,

Jamie Thomson has a sample package here:

http://blogs.conchango.com/jamiethomson/archive/2005/07/04/SSIS-Nugget_3A00_-Execute-SQL-Task-into-an-object-variable-_2D00_-Shred-it-with-a-Foreach-loop.aspx

|||

Check this feedback:

ForEach enumeration of ADO recordset can cause infinite loop when using checkpoints

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125915