ETL and Data Integration tools - Modern ETL software for everyone

Can you set up a connection that pulls in a server name from a system environment variable? We need to be able to run the same package in different environments (Test, Development, Production, etc.) without making manual changes.

Ideally we would have a configuration file (or database table reference) on each application server where we run packages, that would contain all of the relevant server names (database servers, file servers, etc.) and when the package runs it automatically refreshes all references based on the environment.

Can the DBSL product handle this requirement?

Adrian

Yes it is possible

I would personally use Set Variable Package object to set parameters for different environments
Or you can use table as well (sql data check to get value than save it into different variable using calculation)
Or you can write an sql script and update connections table.

John