Post reply

DTS Package executed.

  • August 18, 2005 at 4:47 am

    #90771

    Hi, Could any one tell me the process to execute DTS package from a Stored Procedure? 

  • August 18, 2005 at 7:24 am

    #583006

    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

    #583450

    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

    #583464

    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