CODEWITHSUNDEEP
visual-studio-2012ssissql-server-2012sql-server-2016
ColinMac
ColinMac

Reputation: 640

Need to update ssis connection manager for almost 1000 packages

My team is updating their SQL Server 2012 to SQL Server 2016, and thus we must update our Visual Studio (2012) SSIS/Data Tools package connections to use SQL Server 2016.

Currently the plan is to do this one by one!

Is there a faster way?

Upvotes: 0

Views: 140

Answers (1)

KeithL
KeithL

Reputation: 5594

Use a config file to set the DB connection.

The Connection Manager name needs to be the same though.

This allows you to run the same package in different environments as well. So you can have a config file for DEV, TEST and PROD.

We configure DB conn and file paths for each environment.

Upvotes: 1

Related Questions