Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2014-06-13 : 09:04:00
|
| 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
30421 Posts |
Posted - 2014-06-13 : 14:40:52
|
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 |
 |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2014-06-13 : 15:49:33
|
| Thanks for u r reply swepeso....where and how can I find to set the proper ending value for Foreach loop container |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-06-13 : 16:07:49
|
In the properties for the container.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2014-06-13 : 18:22:03
|
| I have checked the properties of the container....but couldnt find anywhere to set the proper ending value... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-06-14 : 04:49:16
|
What are you doing "For each" on?
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|
|
|
|
question related to foreach loop container