When you use Integration Services to create package you are required to create a connection to the database. I would like to know if there is a way to configure a variable to configure all the object that require a database connection to connect using the variable instead of having to configure them all one by one if you need to change the connection to a different database.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I have a question on SQL Server Integration Services
- Thread starter EM1107
- Start date
fredericofonseca
IS-IT--Management
To add to the link above.
Most people will have a initial configuration on a file which name and location are set on an environment variable.
The initial configuration then points the remaining configuration entries required by the package to a SQL Server database table with all other configuration entries.
The above makes it easier to maintain configurations and it is also easy to change them from one environment to another
Regards
Frederico Fonseca
SysSoft Integrated Ltd
FAQ219-2884
FAQ181-2886
Most people will have a initial configuration on a file which name and location are set on an environment variable.
The initial configuration then points the remaining configuration entries required by the package to a SQL Server database table with all other configuration entries.
The above makes it easier to maintain configurations and it is also easy to change them from one environment to another
Regards
Frederico Fonseca
SysSoft Integrated Ltd
FAQ219-2884
FAQ181-2886
- Status
Similar threads
- Question
- Locked
- Question