hi, when will we go for ADO enumerator AND Variable enumerator in or for each loop. can u explain clearly

For each ADO enumerator is used to iterate through the values saved in an object variable. Well, I have never used "For each from variable enumerator" but this link can help you in case you have not checked the same: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/038da15c-321d-4b73-959f-9e34e841f649Nitesh Rai- Please mark the post as answered if it answers your question

The Foreach Loop Container is a looping mechanism that allows you to loop through a collection of objects. Generally, Foreach ADO Enumerator Loops through a list of tables or rows in a table from an ADO set. And Foreach Variable Enumerator Loops through an SSIS variable, you can use Variable Enumerator to replace ADO Enumerator. For example: http://www.rad.pasfu.com/index.php?/archives/18-Foreach-Loop-based-on-Variable-SSIS.html - Variable Enumerator http://www.codeproject.com/KB/database/foreachadossis.aspx - ADO Enumerator Hope this helps, RaymondRaymond Li - MSFT