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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 question related to foreach loop container

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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...
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -