How do you use DTS to run a .bat file daily?

[Scruby]

Someone told me that I can use DTS to run a .BAT file to delete a file on a daily basis, can someone please tell me how to set this up?

 

[kaymc]

You can, and here's how:

Go into your enterprise manager, go down to Data Transformation Services / Local Packages. Right click to create a new package. When your new package opens up, go to the Task Menu and select EXECUTE PROCESS TASK.

Click in the elipse next to the Win32 process task and navigate your way to the batch file you want to call. Click Open and then OK.

Go to the top menu and save your new package. You should then see your new package in the list of local packages. Right click on it and select SCHEDULE PACKAGE.

All that remains is for you to select the time you want your batch file to run, and click OK.

 

[Scruby]

Thanks KAYMC that worked just fine.

Scruby