SSIS Package created in server A and to be used in Server B

Yu, Xueke (JP - AB 余 雪柯) 0 Reputation points

Hi there,

I am a newbie to SSIS packages, please forgive me if this question is too entry level.

I am creating several new SSIS packages for CSV imports. The server which I used to create these packages are for internal development only, while the ultimate goal is to use the packages on a different server.

The problem is that server B has a different name for the SQL database. Inside the connection manager the following would be different.

  • Data Source = ServerA\DB001
  • Data Source = ServerB\DB002


It seems that the last time we used an SSIS package, the only thing that was done was to copy the necessary SSIS packages from Server A to Server B. However, it is obvious that if I want to execute the SSIS packages via command line, I would have to deploy them onto the Integration services for Server B.
Does anyone know how the process should be done in order to use the SSIS packages in Server B with command line? Thanks in advance,



SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,523 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 43,166 Reputation points

    You can use a SSIS package configuration file with the destination server name, then you only have to modify the config file depending on which server you want to access.


    and follow-up lessons