change the executing machine

  • Hi, I have a package installed on a SQL 2012 instance (called "instance A") in the SSISDB catalog. On a different instance a job invokes the package. When the package runs it is reported as running on the instance where it is installed - "Instance A".

    Is it possible to have the package execute on a different instance and if so how?

    Thanks.

  • No matter how the package is invoked or from where, it will run on the machine it is saved in. What exactly are you aiming for ? The fact that the package ran on instanceA is not incorrect.

    ----------------------------------------------------

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

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