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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2005-09-22 : 11:49:25
|
| Hi,Is this the correct sql to execute a DTS package pls?xp_cmdshell 'DTS Name' |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-09-22 : 11:53:13
|
| You'll need to specify a full physical path... |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-09-22 : 12:29:45
|
| Look up the command line utility "dtsrun" |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-22 : 23:21:42
|
| That utility has been a lifesaver (and if you can say that you've had a sorry life).MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2005-09-23 : 03:33:03
|
| Hi,I think I should have mentioned that I have created a scheduled job. In the job instead of the encrypted name for the dts package, I would like to actually place the name of the DTS package to be run at a particular time.Do I still use the dtsrun command in the scheduled job?Thanks |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-09-26 : 03:26:36
|
You can have the name of the package if you want (I do). See BOL.quote:
That utility has been a lifesaver (and if you can say that you've had a sorry life).
Another favorite 'utility' is "dtswiz". , thanx for reminding me... |
|
|
|
|
|
|
execute dts in sql