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

Yu, Xueke (JP - AB 余 雪柯) 0 Reputation points
2023-12-06T00:41:51.43+00:00

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,

Best,

Roxie

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
    2023-12-06T11:19:33.24+00:00

    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.

    See

    https://learn.microsoft.com/en-us/sql/integration-services/lesson-5-2-enabling-and-configuring-package-configurations?view=sql-server-ver16

    and follow-up lessons