Post reply

Lost ForEach File Enumerator in For Each Task

  • September 29, 2006 at 12:26 pm

    #114968

    I seem to have lost the selection for the ForEach File Enumerator in SSIS on my local box. When I drop the Enumerator combo box on the collections page for a ForEach task the selection for a File Enumerator is no longer there.  Have tried uninstalling and reinstalling SSIS and then re-applied SP1.

    Anyone have any ideas how to get this back????

    Tim

  • October 2, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • October 2, 2006 at 10:57 pm

    #663769

    Try this and see if it works:

    1. Right clink anywhere in the 'Toolbox' bar and display a context menu.

    2. Select 'Choose Items...' context menu

    3. Select the 'SSIS Control Flow Items' tab. Be patient for the list the be displayed. Check the box next to the item 'Foreach Loop Container'.

  • October 3, 2006 at 3:55 pm

    #663978

    I have the ForEach Loop container in my toolbox. What I am missing is the file enumerator in that container. I have tried removing the control from the toolbox and then replacing it using the method you outline. But I still have the same problem in that when I put the ForEach loop on the flow design surface I can not select a file enumerator.

    Tim

     

  • October 3, 2006 at 6:16 pm

    #663985

    My apologies for misunderstanding your problem.

    When you said "When I drop the Enumerator combo box on the collections page for a ForEach task", can you explain exactly how you achieve this?

  • October 4, 2006 at 11:49 am

    #664144

    First I put a Foreach Loop Container on the Control Flow work surface by opening the toolbox and dragging the icon onto the work surface. Then I double click the control to bring up the Foreach Loop Editor. Then I click on the word "Collection" in the left panel. The in the grid at the top of the right side I then click on the right box on the row that is labeled "Enumerators" on the left side of the grid. This brings up a arrow that if you click opens the select list of a combo box. In my list I only have the following:

    "Foreach ADO Enumerator", "Foreach ADO.Net Schema Row Enumerator", "Foreach From Variable Enumerator", "Foreach NodeList Enumerator", "Foreach SMO Enumerator"

    When I look at another box with SSIS installed I see the above 5 enumerators plus "Foreach File Enumerator" and "Foreach Item Enumerator". At this point is is on the file enumerator that I am needing to get working again.

     

    Thanks,

    Tim

     

     

  • October 4, 2006 at 7:08 pm

    #664216

    I was more interested in how you managed to remove the File Enumerator from the enumeration list!

    Not sure if this will work, but try closing all running applications, and copy all the contents from the folder 'C:\Program Files\Microsoft SQL Server\90\DTS\ForEachEnumerators' (assuming that you've selected a default installation of SS2005) from your other box to the one that's not working. Otherwise, check for files that are missing and just copy those. It's possible that the foreachfileenumerator resource file in 'C:\Program Files\Microsoft SQL Server\90\DTS\ForEachEnumerators\Resources\1033' is corrupt.

  • October 5, 2006 at 8:14 am

    #664328

    Wish I knew how I lost the enumerator. It was on my machine and functioning fine. Did some software installing of various things and some service packs. A few days later I went to use the Foreach file and it was no longer there. Not really sure where in the process it disappeared as I was not checking it after each install/change.

    I will try copying the files/directories you suggest and see what happens.

    Thanks,

    Tim

     

  • October 5, 2006 at 6:42 pm

    #664497

    It looks more like installation of service packs or other applications that might be causing the problem. A recent post in a microsoft forum describe a similar problem, but its resolution was not precise. Have a read of this link http://support.microsoft.com/kb/913817

    Note that article does not describe your problem, but that the issue might be related to permissions in the registry preventing SSIS from enumerating SSIS components properly, and how to determine whether this is the case.

  • October 10, 2006 at 8:42 am

    #665020

    Paul,

    I tried the technique that was laid out in the knowledge base article. I did have a key that had the security issue. It was for a lexmark printer. Changed the permission so that I now get no bad key acording to the test program.

    Unfortunately, it has not solved my lost enumerator problem.

    Tim

     

     

  • October 10, 2006 at 11:27 pm

    #665132

    Thanks for posting the results of your investigation Tim. At least something was 'fixed'!

    Since you mentioned that the issue arose out of nowhere, the only thing that could have caused it would be installation of related microsoft software, service packs or fixes. Your sysadmin guy should be able to help you track this down. You may need to uninstall some software and reinstall SSIS on your computer. Otherwise, have your computer rebuilt from scratch. Anyone else who might be able to help Tim?

  • November 8, 2006 at 11:16 am

    #670661

    I have the same problem...Any solutions yet?

     

    Jason

  • January 22, 2007 at 10:46 am

    #684750

    I had the same problem... I finally was able to get things working again using:

     

    regsvr32 "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\Microsoft.SqlServer.ForEachFileEnumeratorWrap.dll"

     

    Hope this helps.

     

    tjk

  • November 10, 2010 at 7:33 am

    #1248870

    I struggled with this exact same issue--it *was* the Lexmark software!!! Once I uninstalled and rebooted, I could see the 7 enumerators instead of only 5.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply