dependency Schedule Tasks in Windows XP
i am running the packages through windows schedule task . i have the dependency in packages . how can i add dependency in windows schedule task . thanks.
October 21st, 2010 7:52am
Can you elaborate what you meant by dependency in packages?
October 21st, 2010 7:59am
i have 40 packages . first 20 packages load individual tables. after that i have to join those tables using some more packages. And all those table to make big one table like fact table (you can say.)
October 21st, 2010 8:04am
i can not use sql agent problem here .. i tried all possible ways to use sql agent and not worked . plz do not suggest to use sql agent . i want to know if dependency possible in windows schedule task .
October 21st, 2010 8:06am
Hi kiranshiva, Each Windows schedule task is independent. So, it is not possible to add dependency in Windows schedule tasks. In this case, I would suggest you using Parent-Child package. We can first run the 20 child packages, and then the other 20 packages after the 20 child packages are finished. All of this can be done in the parent package. For more information, please see: Execute Package Task: http://msdn.microsoft.com/en-us/library/ms137609.aspx If there is anything unclear, please don't hesitate to ask. Thanks, Jin ChenJin Chen - MSFT
October 25th, 2010 6:14am