SSIS - Create Dynamic Data Connections for NAV/BC

https://www.sqlservercentral.com/articles/creating-a-robust-ssis-development-environment-using-the-ssis-catalog

• Right click data connection>Parameterize
• On the top, select "ConnectionString"
• The value field will show the entire connection string
• Put the entire thing into a parameter
• Switch the ConnectionString property to use a parameter
• Now you can update your parameter value with the exact connection string you want the connection to use.
• On each data connection, you can also go to Properties>Expressions
• Here you can use a variable as a connectionstring