DTS Package executed.

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

peterhe SSChampion Points: 11469 More actions · Answer 1

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.

AndyLoughman SSC-Addicted Points: 422 More actions · Answer 2

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.

Ditthima Srinual-aed SSC Enthusiast Points: 104 More actions · Answer 3

SSC Enthusiast

Points: 104

August 19, 2005 at 4:52 am

Now , I can do it!!!

Thank you.

Cookies on SQLServerCentral