Post reply

How to run ssis package from Sqlstored procedure?

  • August 9, 2011 at 7:04 pm

    #245946

    Hi,

    How to run ssis package from Sqlstored procedure?

  • August 10, 2011 at 3:53 am

    #1366445

    Put the SSIS package in a SQL Server Agent job and start the job using sp_start_job.

    Or use xp_cmdshell to run the dtexec utility that will start the SSIS package.

    Personally I find the first option easier.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

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