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 |
|
MBeal
Posting Yak Master
110 Posts |
 Posted - 2002-04-04 : 11:41:05
|
| Trying to execute a DTS Package using SQL Agent Job. How can I locate the unique identifier for the DTSRun command? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-04 : 11:44:46
|
| Why not use the /N switch and use the package name instead? |
 |
|
|
MBeal
Posting Yak Master
110 Posts |
Posted - 2002-04-04 : 11:46:07
|
| Thank you!!!Edited by - MBeal on 04/04/2002 11:53:14 |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-04 : 11:53:18
|
| Look up "dtsrun" in Books Online, it lists all of the switches and how to use them. |
|
|
|
philh
Starting Member
18 Posts |
Posted - 2002-09-10 : 08:19:58
|
| When I try to use the /N switch (SQL2K), I get an error "Invalid command option." The rest of the message shows the options preceded by a tilde. I've tried tilde, no tilde, DTS package name in single quotes, double quotes, without quotes, no joy.Any ideas?Phil HegedusichSenior Web DeveloperIIMAKhttp://www.iimak.comThe best thermal transfer printer ribbons on the planet |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-10 : 14:05:05
|
| Post your dts command so we can see what's wrong.In SQL2k the easiest way to generate the command is to use dtsrunuiGoto Start>Run and type in dtsrunui and hit enter. This pops up a dialogue box to allow you to pick the package and server. Once this is done click on the advanced button and on the advanced tab hit generate, this will generate the command for you - I tend to remove the /G package identifier as I always run the latest version of a package. You can also choose to encrypt the command, schedule it and pass in global variables.HTHJasper Smith |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-09-11 : 03:35:41
|
| If all else fails, just right click on the package and select "Schedule Package" from the Local Packages view instead. |
|
|
|
ksw
Starting Member
24 Posts |
Posted - 2002-09-13 : 13:10:17
|
| mr_mist has the right idea. When you select the Schedule Package option, it automatically creates the SQL Agent Job. The extra bonus here is that when you write out the DTSRun parameters, such as user id & password, anyone that has access to open a job can read the info, but the Schedule Package option encrypts all of that info. It uses the /~Z switch and the parameter in one of my jobs is a 326 character long hex value. I betting that keeps your login info fairly secure.--KSW |
|
|
|
|
|
|
|
|
Execute DTS Package using SQL Agent Job