December 6, 2007 at 10:23 am
I have already created a DTS Package and it is now showing up in the Local Packages, I would like to take that package and create a DTSRun /~XXXXX so i can copy and paste into a schedule job as one of the job steps.
Can you tell me how i can take the already created DTS package now setting in the Local Packages and generate the DTSRun /~XXXXX so i can copy and paste it in the SQL job scheduler as a runable step using Operating System Command (cmdExec) for job function.
Thank you,
December 6, 2007 at 11:12 am
I used window authentication in this.
EXEC master..xp_cmdshell 'DTSRun /S "ServerName" + /E /N "PackageName" /W "0" '
If you don't use window authentication, then you have to put in user and password.
Instead of /E you use /U "user" /P "password"
December 6, 2007 at 11:13 am
Sorry, it should be
EXEC master..xp_cmdshell 'DTSRun /S "ServerName" /E /N "PackageName" /W "0" '
December 6, 2007 at 11:36 am
Use the DTSRUNUI utility to generate the command.
Great article here; http://www.sqldts.com/301.aspx
Norman
DTS Package Search
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply