sql server dts: Creating a Job in SQL Server Agent 2000 to Run a DTS Package -- sql server dts

Creating a Job in SQL Server Agent 2000 to Run a DTS Package

UncleMonkey
5/14/2007 3:11:03 AM

sql server dts:

I am trying for the first time to create a job to start at a specific time to
start a DTS package. What I need to put in the Type and Command when creating

Re: Creating a Job in SQL Server Agent 2000 to Run a DTS Package

Allan Mitchell
5/15/2007 7:30:16 AM

Hello UncleMonkey,

The easiest way is of the package is stored as a local package on SQL Server
then right click the package and choose schedule frmo the context menu.

You can also run as a CmdExec jobstep and use DTSRun. DTSRun has lots of
parameters so you may want to look at DTSRunUI (Start | Run | DTSRunUI)

This URL should help

http://www.sqldts.com/301.aspx

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]