Shredding Recordset Object In ForEach Loop - While Using Checkpoint

I think this got to be one of the annoying bugs within SSIS.

I have a SQL Task which returns the result set to a variable called "Pkg_Obj_ResultRet".

Then using Foreach Loop container I shredd the result set. I have a Foreach ADO Enumerator and the Enumeration Mode is set to Rows in the first table. Shredded results are mapped to 2 variables called Pkg_Str_SSISStreamName and Pkg_Str_SSISVarNameControlFile.

Inside Foreach Loop Container I have "Execute Package Task" which execute package using these variables. Here comes the fun.

The iteration works fine first time, runs the second iteration successfully and then it try to run second iteration in an infinite loop.

This happens when you have SaveCheckPoints option set to True. If you want to use checkpoint, you can't get this to work unless you set the Foreach Loop TransactionOption = Required.

I think this is a bug and I have raised it with Microsoft.

Thanks
Sutha