I have to run a few DTS packages and stored procedures in between before runing the DTS packages. This a job that I am taking over so the biz. logic is something that I can't recreate.
Now question is Is there a way I can automate this process.
I have approximately 3 DTS packages and 3 stored procedures.