Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Problem in foreach loop
Add to briefcase

Problem in foreach loop Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
sathiyan00
Posted Monday, September 17, 2012 10:28 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 11:38 PM
Points: 60, Visits: 323
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
Post #1360549
aaron.reese
Posted Tuesday, September 18, 2012 2:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 7:33 AM
Points: 234, Visits: 441
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.
Post #1360610
sathiyan00
Posted Tuesday, September 18, 2012 4:38 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 11:38 PM
Points: 60, Visits: 323
sorry friends i forgot to mention. it is in ssis....
Post #1360672
Animal Magic
Posted Tuesday, September 18, 2012 4:52 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 983, Visits: 13,348
Is this just within a single existing package or do you see the same behavior if you create a new package?
Post #1360678
Jason-299789
Posted Tuesday, September 18, 2012 4:56 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:38 AM
Points: 803, Visits: 2,123
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
Post #1360680
Animal Magic
Posted Tuesday, September 18, 2012 5:05 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 983, Visits: 13,348
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
Post #1360684
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.