Hi, I have a legacey DTS package in SQL 2005. Can you please tell me how to schedule it through SQL agent job by giving DTS package name? Thanks Illiyaz

Assuming your DTS package is in your SQL Server 2005, go to the \SQL Server Agent\Jobs\ tree in the SSMS and create a new Job, Create a new step in it that will run the following shell command: DTSRun /S servername /E /N "dts package name" Try to execute your package. Note: you need to be able to execute command line calls. Arthur My Blog

Hi Arthur, I tired in same way but my job is getting failed with below error. Error: The process could not be created for step 1 of job 0xB3D5AB8577E83E46AAA3251171AEBFFA (reason: The system cannot find the file specified). The step failed.

I think you do not have the DTSRun Arthur My Blog

Try running just the command line itself. Does it work? Probably not. Reason is you overlooked something and/or under/mis-configured something. Did you do any preps to handle DTS packages?Arthur My Blog

Did you install the SQL 2000 DTS legacy support? It is a separate installation option that you have to enable before you are able to execute old DTS packages. You can check more here.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/