How do you schedule a DTS package?

Question

How do you schedule a DTS package?

STEVE-R

Old Hand

Points: 301
More actions
September 13, 2006 at 1:46 pm

#68947

This is my first attempt to setup a scheduled DTS package. I have figured out how to build the package, but I do not know how to schedule the package. I noticed that there is a "schedule" option in the DTS wizard but I also know about the SQL Server Agent for setting up "Jobs". Does anyone have a simple answer for this?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

They both work....

I'd use the dts option to schedule the job, then if needed I'd go edit the schedule with the agent (kess work that way). You'll understand once you see the generated code .

lucky-80472 SSCertifiable Points: 7793 More actions · Answer 2

Hi Steve,

As you said in your post, you need to select "schedule" option in the DTS and select the time for execution of your package. It will automatically create a job with the encrypted value for the DTS package. This can be viewed from the job properties(steps).

Hope this helps.

Thanks

Lucky

STEVE-R Old Hand Points: 301 More actions · Answer 3

STEVE-R

Old Hand

Points: 301

September 13, 2006 at 2:29 pm

#660241

Found it, works fine. Thanks for the help.

ChrisMoix-87856 SSCertifiable Points: 7288 More actions · Answer 4

You can also right click the DTS package itself and choose Schedule Package - no need to open the DTS package.

It's in Enterprise Manager under Data Transformation Services, Local Packages.

(That's the initial package schedule creation. Go into SQL Server Agent Jobs to change the schedule, etc. )

Norman Kelm SSCommitted Points: 1922 More actions · Answer 5

Steve,

The right click schedule is great start to initially get the package scheduled. But to take advantage of all of DTSRUN's command options, say passing a global variable on the DTSRUN command, familiarity with DTSRUNUI.EXE would be very helpful. Also with a multi step job if the encrypted DTSRUN commands, if the steps are not documented carefully then 6 months later as the job is edited again figuring out which DTS package is being run in that encryted command may be frustrating.

A great feature of the DTSRUNUI utility is its ability to generate the DTSRUN command. Here is a an excellent article on how to generate a DTSRUN command. http://www.sqldts.com/default.aspx?301

Remember that the DTSRUN in the job step can usually use /E (Windows Authentication) since the DTSRUN is running on the SQL Server and as the user defined in the SQL Server service LogOn tab.

Norman

get DTS Package Search at http://www.gerasus.com/

STEVE-R Old Hand Points: 301 More actions · Answer 6

Thanks for all the help and advice. I have what I need on this issue.

SR