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.

Can you elaborate what you meant by dependency in packages?

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.)

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 .

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