Share via

SSIS - SQL instance migrated - Need to update 400 SSIS packages

Henely, Davis 1 Reputation point
2022-11-02T18:18:24.007+00:00

Hello and TYIA,
The SQL instance to which we have hundreds of SSIS packages connecting to is being migrated to a new instance on a new server. Is there any way I can programmatically update the connections strings in each package? I would hate to have to do this manually.

Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
517 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 35,556 Reputation points
    2022-11-07T01:25:47.493+00:00

    Hi @Henely, Davis ,

    As far as I know, temporarily we could not programmatically update the connections strings in your situation. You need to modify it manually.

    And this time you may refer to parameterizing-database-connection-sql-server-integration-services in case the SQL instance changed again.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments