Dear all
i got a problem. The situation is i got three package(a,b,c) by
schedule. I wanted to run package c when package a and package b completed.
Does anyone have any idea to slove this problem ?
Thanks.

you can create a package with 3 execute package tasks,
or you can create a job in the SQL Agent to run the 3 packages in sequence.

"gary" <garyli (AT) globalsuntech (DOT) com> a écrit dans le message de news:
O0uR2k7kEHA.3496 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Dear Willgart:
Thanks for your help. I have another question. In this case I had another
package d . It also run after package a and packed b complete. If I created
a package with 3 execute package(a,b,d) tasks, the package a and package b
will run twice. It's will waste resource , Do you have any better solution ?

Thanks a lot.



<Jéj? <willgart (AT) BBBhotmailAAA (DOT) com>> ¦b¶l¥ó
news:O10$UR8kEHA.3608 (AT) TK2MSFTNGP09 (DOT) phx.gbl ¤¤¼¶¼g...

well...
generally what I do is simple:
A create a lot of "small packages" each package do 1 job only
And I've a master package which sequence the execution of all of these
packages
So I insure that I never run twice the same package.

Another solution (but not tested) could be :
* add a global variable in each package "BatchID"
* add a table in your database which contain 2 column : Package name, last
batch ID

Now at the begining of your execution, get a new batchid and pass it to
every package.
In each package, compare this global variable to the "last batch id", if the
2 values are equals, then disable the next step in your package to stop his
process
if the betch id is different, then the process runs correctly, and at the
end of the package, store the batch id in the database to change the "Last
batch id" column.

I hope I've helped you

"gary" <garyli (AT) globalsuntech (DOT) com> a écrit dans le message de news:
%23QE0gh9kEHA.1356 (AT) TK2MSFTNGP09 (DOT) phx.gbl...