March 3, 2011 at 11:30 am
Hi
I have a parent package which will be calling a child package. Can the parent package call the child package more than once? i.e. execute the child package repeatedly without waiting for the first execution to finish.
(By repeatedly I'll be calling the same child package 8 times...) I know that I can drop 8 execute packages and not link them, but maybe there is a neater way to achieve this.
Regards
Brian
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
March 3, 2011 at 12:22 pm
At the moment, I can only think of 8 parallel Execute Package Tasks who all call the child packages, so yeah, not so neat 😀
You could also call 8 different SQL Server Agent jobs who all do the same, but that is basically just the same.
Maybe you can force something in a script task in .NET, but my knowledge doesn't extend that far...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 3, 2011 at 1:00 pm
March 4, 2011 at 12:38 am
Great Thanks! I'll have a look...
Regards
Brian
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply