Foreach loop container question RRS feed

  • Question

  • I am using visual studio 2005 and sql server 2005. When I move a foreach loop container onto the control flow area from the Toolbox and do Edit - Collection - Enumerator I do not see a selection for Foreach File Enumerator. I have seen numerous examples of this in several blogs when I have googled the particular problem I am working on (A file system task of copying and renaming a file in a directory). Why would I not have the selection in my Enumerator drop down? Any help is appreciated.

    BTW, here is what is in the drop down:

    Foreach ADO Enumerator

    Foreach ADO.NET Schema Rowset Enumerator

    Foreach From Variable Enumerator

    Foreach NodeList Enumerator

    Foreach SMO Enumerator



    Monday, June 27, 2011 2:41 PM


  • Has to do with some third party apps installed and you will need the latest SP to fix

    see this to resolve: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/9d10a287-321e-4157-b6ab-06bc5890dcb9/

    Arthur My Blog
    By: TwitterButtons.com
    • Proposed as answer by Kalman Toth Monday, June 27, 2011 4:58 PM
    • Marked as answer by Challen Fu Wednesday, July 6, 2011 7:15 AM
    Monday, June 27, 2011 2:59 PM