Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lba
Starting Member
3 Posts |
 Posted - 2003-03-12 : 10:10:05
|
| On my systems (sql 2000 and sql 7)the jobs are set up to run DTS packages. I can create a dts package no problem but don't know how to get the dts package into a job. The existing jobs have long dts identifier, how do I find this, or is there another way to get the package into the job? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-12 : 10:18:32
|
| Right-click the DTS package in Enterprise Manager, on the menu is an option for Schedule Package, click that and fill out the information. You can omit a schedule. It will create the job and you can edit it afterwards if desired. |
 |
|
|
|
|
|
Jobs and/or DTS packages