Re: Creating a Job in SQL Server Agent 2000 to Run a DTS Package
- From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 15 May 2007 07:30:16 +0000 (UTC)
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
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 a job step. Or is there an easier method?
.
- Prev by Date: Re: Another DTS Scheduling question
- Next by Date: Re: DTS Import Record Update Trigger.
- Previous by thread: Another DTS Scheduling question
- Next by thread: Re: DTS Import Record Update Trigger.
- Index(es):
Relevant Pages
|
