Scheduling a DTS Package

5 pts.
Tags:
DTS
DTS packages
SQL Server
SQL Server Enterprise Manager
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following