Problem in foreach loop

Question

Problem in foreach loop

sathiyan00

SSCommitted

Points: 1879
More actions
September 17, 2012 at 10:28 pm

#261803

Hi friends,
I have problem in foreach loop.foreach loop doesn't show the for each file enumerator and foreach item enumerator in collection->enumerator drop down.but remaining things are working(foreach ado enumerator etc.,)
Thanks and Regards
Sathiyan.R

Viewing 6 posts - 1 through 5 (of 5 total)

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

aaron.reese SSChampion Points: 13498 More actions · Answer 1

Wrong board I think...

SQL doesn't use foreach loops, it is a set based language. You apply the same change to every record at the same time (unless you are using cursors, but lets not go there...)

Having said that, post your code and we will point you in the right direction.

sathiyan00 SSCommitted Points: 1879 More actions · Answer 2

sorry friends i forgot to mention. it is in ssis....

Animal Magic SSChampion Points: 13964 More actions · Answer 3

Is this just within a single existing package or do you see the same behavior if you create a new package?

Jason-299789 SSC-Insane Points: 21601 More actions · Answer 4

sathiyan00 (9/17/2012)
Hi friends,
I have problem in foreach loop.foreach loop doesn't show the for each file enumerator and foreach item enumerator in collection->enumerator drop down.but remaining things are working(foreach ado enumerator etc.,)
Thanks and Regards
Sathiyan.R

Its the wrong forum, but I've seen this before, try closing down BI studio and then reopen the solution and package. If that fails to work then delete and recreate the FOREACH container adn it should reappear.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Animal Magic SSChampion Points: 13964 More actions · Answer 5

Yeah try Jasons suggestion. The dll it uses lives here \MIcrosoft SQL Server\100\DTS\Binn\DTS.dll (assuming 2k8)

If Jasons suggestion doesnt work you could try copying the DLL from someone elses machine or better still just reinstall BIDS on your machine