Running DTS to create Excel file in a job

[dndaughtery]

When I run a dts package to create an excel spreadsheet I always have to go into the dts designer and create the table. How can I setup a dts to run in a job that runs on a regular daily schedule. (Like at 5pm every day)Without me having to worry with it?

 

[FALCONSEYE]

on the very last page of the DTS import/export wizard there is an option called "When"
You can check schedule DTS package for later execution then click on the ...
It brings "edit recurring job schedule" and you can pick daily, occurs once @ 5pm.
hope it helps

http://www.jetansolutions.com