Wait for DTS to complete before updating

[tman135]

I have a stored procedure that does two things...
1) It runs a series of jobs which run DTSs to transfer data into temp tables
2) It then runs a series of jobs that run stored procedures to process the data.

Question is how can I ensure that the DTSs run to completion before the stored procs run??

 

[RickCole]

You could do something like this:

First step in your DTS package sets say a flag and date to indicate Start and Start time in a table on your database. Last step sets the flag and date to successful and an end time.

Subsequent stored procs check the flag status and react accordingly.

Altenativly use the success/failure workflow within yout DTS package and include all your stored procedure within steps inside the package.


Rick.