August 27, 2003 at 8:17 pm
Hi there.
Thanks for all your help . This forum is outstanding.
Here it’s the issue I’m facing now. I've got a VB script which executes a number of packages in the following order.
If Year( DTSSource("Date") ) < 1900 Then
RunPackage "A”
RunPackage "B”
RunPackage "C”
Else
RunPackage "D”
End If
Main = DTSTransformStat_OK
The packages B and C has less tasks than the package A, however I need to guarantee that they run after successful completion of package A.
By putting these packages in the above order, can I guarantee that the packages B will run after only after successful completion of package A, and so on.
Thanks in advance
Lou
September 2, 2003 at 8:00 am
This was removed by the editor as SPAM
September 2, 2003 at 10:46 am
Not being a DTS kinda guy, if you always would run ABC, why not build that into package A? A simple way to do what you're asking is to have each package set a flag (row in a table, disk file, whatever), then in your app you wait for that flag to be set before you continue execution.
Andy
September 2, 2003 at 7:01 pm
Thanks Andy for you help.
I do appreciate that.
Lou
September 9, 2003 at 2:23 pm
Another I idea that I have grown to love is actually not calling the packages from the page but from a Stored Proc.
I find it is much easier to call one proc and have it do your bidding from within SQL.
I can muster up a link if needed
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply