SSIS Foreach Loop "Foreach file enumerator" option missing

Topics: Resolved
Nov 18, 2010 at 8:37 PM

When I open the editor of the Foreach container and list the enumerators available the "Foreach File enumerator" is not listed all of the others appear.

Coordinator
Nov 19, 2010 at 7:05 PM

Sorry. I don't understand. Are you saying that this problem only occurs when BIDS Helper is installed? Or are you saying there's some BIDS Helper screen that's not showing the foreach loop task correctly? Can you clarify?

Nov 19, 2010 at 8:14 PM

This was an observation between two different SSIS systems. The first one was from my desktop VS2005 w BIDS helper v1.4.3 running SQL 2005 developer edition. The second was from our test server MSS 2003; running SQL 2005 with VS2005 and BIDS helper v1.4.3. When I added a foreach loop in each system I got different results

Coordinator
Nov 20, 2010 at 1:08 AM

I'm 95% sure this has nothing to do with BIDS Helper. Can you help us prove this one way or the other? Can you uninstall BIDS Helper and see if that fixes the problem? My guess is that it's a SQL installation problem, not a BIDS Helper issue, but please let us know how it goes.