Post reply

Executing SSIS 2012 from stored proc in different server

  • May 6, 2016 at 12:27 pm

    #313832

    I have SSIS 2012 (SSDT) residing in one server and I need to run the SSIS package from a different server.

    What is the process for that?

  • May 6, 2016 at 1:09 pm

    #1877259

    PJ_SQL (5/6/2016)

    I have SSIS 2012 (SSDT) residing in one server and I need to run the SSIS package from a different server.

    What is the process for that?

    not quite sure what you are asking.

    do you need to change the server/database the "one server" package uses(changing the connection managers?) or do you mean you know the package is it deployed on the "different server" to the SSIS catalog there? (ssisdb?)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 6, 2016 at 1:12 pm

    #1877260

    Package is deployed in ssisdB in one server(Server A)

    I need a stored proc to execute that package. Stored Proc will be in different server(Server B)

    So SP in Server B need to execute package in Server A.

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

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