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,487 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.
503 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 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 No comments