5 pts.
 Scheduling a DTS Package
Hi On MS Windows Server 2003 I have a DTS Package in SQL Server Enterprise Manager. The DTS package runs fine in SQL Server Enterprise Manager. How do I add that DTS package as a scheduled task? Thanks P

Software/Hardware used:
ASKED: May 13, 2008  11:48 AM
UPDATED: May 14, 2008  8:00 AM

Answer Wiki:
There are a couple of options. 1. Bring up the list of DTS packages. Right click on the DTS Package and select Schedule Package. Select the schedule and click OK or Save. 2. Create a new job, and add a job step. The step type will be Operating System Command. The command to run is dtsrun.exe. You can run this from a command prompt with /? to see the list of options. If you use the first technique it simply creates a SQL Job for you, so the end result is the same either way.
Last Wiki Answer Submitted:  May 14, 2008  7:59 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,520 pts.