August 18, 2005 at 4:47 am
Hi, Could any one tell me the process to execute DTS package from a Stored Procedure?
August 18, 2005 at 7:24 am
To run a dts package file:
exec master..xp_cmdshell 'dtsrun /F "C:\test.dts" /E'
E: trusted connection.
You can also run dts packages saved in msdb. Please check bol for the switches of dtsrun utility.
August 19, 2005 at 3:19 am
You could also put the package into a job and use msdb..sp_start_job if you need the package to run on the server.
August 19, 2005 at 4:52 am
Now , I can do it!!!
Thank you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply