Post reply

Run SSIS package from stored proc

  • March 21, 2016 at 3:46 pm

    #314221

    How to run SSIS package in MSDB and has input variable from stored proc?

  • March 22, 2016 at 9:27 am

    #1866838

    You can create a SQL Agent Job that runs the SSIS package and start that job using sp_start_job. There is no way to pass a value to SQL Agent job, so you could have the stored procedure save the values in a table and have the SSIS package read the values from that table into variables.

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

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