Call the DTS from an SQL agent job as
DTSRun /S Servername /E /N "DTSName"
Select type as Operating System(cmdExec) from the drop down
DTSName = Name of the DTS that you have created
Servername= Name of your server where the DTS is created
This blog is created to add all the information and experiences that I have learnt while working on MS sql server as a DBA. The blog is also updated frequently with the real world problem that I encounter hands on at work and the resolutions to resolve them. I hope this blog will be of some use to you and you will revisit. Thank you for stopping by and you are welcome to leave comments.
Showing posts with label Schedule jobs. Show all posts
Showing posts with label Schedule jobs. Show all posts
Wednesday, February 1, 2012
Subscribe to:
Posts (Atom)