 | |
execute dts
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
execute dts -
02-15-2005
, 06:09 PM
#2
| |||
| |||
|
|
How to execute dts from stored procedure? How to use xp_cmdshell to evoke dtsrun? I have the following parameters: dts package name="myPackage" UserId="uid" Password="pass" Thank you! |
#3
| |||
| |||
|
|
How to execute dts from stored procedure? How to use xp_cmdshell to evoke dtsrun? I have the following parameters: dts package name="myPackage" UserId="uid" Password="pass" Thank you! |
#4
| |||
| |||
|
|
From at stored procedure you can run xp_cmdshell. I would schedule the dts package as a job. I would then copy the command text that it creates (note: I would clean up the command text, but simple scheduling works for most people). It creates a dtsrun script with an encrypted command line. Then delete the job. In VB, I would use a shell command to call the dtsrun command. -- Russel Loski, MCSD.Net "Filipe Madureira" wrote: Hi How can I execute a DTS from a stored procedure or by ODBC? Thanks Filipe Madureira |
#5
| |||
| |||
|
|
In Enterprise Manager, you right click on a DTS package, then click schedule a package. It creates a job. I find that job, edit the job step that runs a command. It creates the dtsrun command line. One can copy that text to run in a stored procedure. -- Russel Loski, MCSD.Net "Allan Mitchell" wrote: Russel. Where does a job step create the command line for you? Are you getting confused with SSIS and DTExecUI? You can do pretty much the same thing through using DTSRunUI and generate your command line there. There are a number of ways of executing packages in this scenario have a look here Execution (http://www.sqldts.com/104.aspx) -- Allan Mitchell http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com | http://www.konesans.com "RLoski" <RLoski (AT) discussions (DOT) microsoft.com> wrote in message news:48D071FD-83B6-4087-B582-95C08EF7F2AE (AT) microsoft (DOT) com: From at stored procedure you can run xp_cmdshell. I would schedule the dts package as a job. I would then copy the command text that it creates (note: I would clean up the command text, but simple scheduling works for most people). It creates a dtsrun script with an encrypted command line. Then delete the job. In VB, I would use a shell command to call the dtsrun command. -- Russel Loski, MCSD.Net "Filipe Madureira" wrote: Hi How can I execute a DTS from a stored procedure or by ODBC? Thanks Filipe Madureira |
#6
| |||
| |||
|
|
Ahhhhh now I see where you are getting it from. Not really the job creating the cmd line rather the scheduling code creating the job + step + cmd line. -- Allan Mitchell http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com | http://www.konesans.com "RLoski" <RLoski (AT) discussions (DOT) microsoft.com> wrote in message news:B078080C-3289-4FCF-B23E-4B1EB321FDAA (AT) microsoft (DOT) com: In Enterprise Manager, you right click on a DTS package, then click schedule a package. It creates a job. I find that job, edit the job step that runs a command. It creates the dtsrun command line. One can copy that text to run in a stored procedure. -- Russel Loski, MCSD.Net "Allan Mitchell" wrote: Russel. Where does a job step create the command line for you? Are you getting confused with SSIS and DTExecUI? You can do pretty much the same thing through using DTSRunUI and generate your command line there. There are a number of ways of executing packages in this scenario have a look here Execution (http://www.sqldts.com/104.aspx) -- Allan Mitchell http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com | http://www.konesans.com "RLoski" <RLoski (AT) discussions (DOT) microsoft.com> wrote in message news:48D071FD-83B6-4087-B582-95C08EF7F2AE (AT) microsoft (DOT) com: From at stored procedure you can run xp_cmdshell. I would schedule the dts package as a job. I would then copy the command text that it creates (note: I would clean up the command text, but simple scheduling works for most people). It creates a dtsrun script with an encrypted command line. Then delete the job. In VB, I would use a shell command to call the dtsrun command. -- Russel Loski, MCSD.Net "Filipe Madureira" wrote: Hi How can I execute a DTS from a stored procedure or by ODBC? Thanks Filipe Madureira |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.