Hi, I have 7 foreach loop containers, all of them parallel to each other. I have data flow task in each loop and i have mapped 25 sources to 25 destinations in each data flow task. All the DFT has the same 25 table mappings. When i am running each loop seperately by disabling the other, they are running fine but when i am trying to run all of them together i am getting error. can anyone help.

Please post your error! Which enumerator are you using? Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Is this the same post that was talking about loading 70 source databases into one destination database using 7 For Each loops of 10 databases each, with 7 iterations of 25 Data Flow pipelines in each? If so, you may be getting errors in the fact that more than one process is trying to write to the same destination table at the same time. Try looping the full 70 times inside ONE loop and I bet the problem goes away.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.