Post reply

Stored Procedure to Execute SSIS package

  • December 9, 2009 at 10:39 am

    #228412

    Does anyone have a Procedure that runs SSIS packages based on the input parameter or no input parameter for some packages? I was going to create one, but thought someone should have it for sure... so wanted to check here... Thanks for the help.

  • December 9, 2009 at 5:47 pm

    #1090291

    While I have not called a SSIS package directly from a stored procedure, I have used sp_start_job to kickoff a job that executes the SSIS package. In my case, this had the added benefit of operating asynchronously so the procedure flow did not have to wait for the package to complete.

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

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