Hi, I have created 3 store procedure and one DTS. I would like to schedule those code and run them in sequential order. Those are the code:
sp_A
sp_B
DTS_moveData
sp_C
Once sp_A is completed sucessfully, I want sp_B to run
then once sp_B is completed sucessfully, I want DTS_moveData to run[ This is where I am getting the most difficult part, where the code is not in store procedure it is in a DTS package, so how to run the DTS after my second sp_B and once the DTS is completed, I want to run sp_C ]
Thanks for your help,
Al
sp_A
sp_B
DTS_moveData
sp_C
Once sp_A is completed sucessfully, I want sp_B to run
then once sp_B is completed sucessfully, I want DTS_moveData to run[ This is where I am getting the most difficult part, where the code is not in store procedure it is in a DTS package, so how to run the DTS after my second sp_B and once the DTS is completed, I want to run sp_C ]
Thanks for your help,
Al