SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 question related to foreach loop container
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

raaj
Posting Yak Master

126 Posts

Posted - 06/13/2014 :  09:04:00  Show Profile  Reply with Quote
Hi,
We are using SQL SERVER version 2005.
I am having a For each loop container and inside that container there are multiple Sequence containers and inside each sequence containers there are Execute SQL Tasks (which are just stored procedures).

Now, when i run sequence containers individually they are running perfectly fine.

But when I run the whole For each loop container, it is just running and running multiple times without ending the process.

I really couldnt figure out what would be the issue?

Any ideas????

Thanks....

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 06/13/2014 :  14:40:52  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You have to make sure the For Each Loop-container has a proper ending value.
It seems you have an infinite loop going on.



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

raaj
Posting Yak Master

126 Posts

Posted - 06/13/2014 :  15:49:33  Show Profile  Reply with Quote
Thanks for u r reply swepeso....
where and how can I find to set the proper ending value for Foreach loop container
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 06/13/2014 :  16:07:49  Show Profile  Visit SwePeso's Homepage  Reply with Quote
In the properties for the container.



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

raaj
Posting Yak Master

126 Posts

Posted - 06/13/2014 :  18:22:03  Show Profile  Reply with Quote
I have checked the properties of the container....
but couldnt find anywhere to set the proper ending value...
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 06/14/2014 :  04:49:16  Show Profile  Visit SwePeso's Homepage  Reply with Quote
What are you doing "For each" on?



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000