Configuration Manager - which configuration type to chose ?

Hot Topic

Getting startec with Integration Services
Some ideas for custom tasks/components
Default Date Format
Cognos to RS
Transaction File Growth
SQL Agent Tokens
Does RS have a time on authentication tickets? (Updated - VS Web Svr related)
Procedure For Installing AdWorks StoreFront samples - "Keypairs" and "CLR layer"
HowTo Union a given query across n duplicate databases
SS2005 Standard (RTM & SP1 CTP1) evaluates sub-queries in wrong order

SQL Server

Simple migration from MySQL to SQL Server Express 2005?
Problem with installing SQL Server 2000
get data from cube based on date range( hierarchy)
Error importing data from oracle database to an SQL database
Errors reported by uninstall tool for SQL Server 2005 (Tools) Express Edition CTP
SQL 7 [DBNETLIB] 2147467259(80004005) [Connection write(send()),] General Network Error
Creating SQL Server 2005 Mobile Edition On Desktop
Trimming characters
SQL Server 2005 Management Studio can't be found
Drillthrough Functionality via Excel Add-in

Configuration Manager - which configuration type to chose ?

It seems to me, that the best way is to have one Environment Varible containing the name of the SQL Server, so that you can look up the configuration in the SSIS Configuration Table when you run the package.

Is this the preferable way of doing it I would like to hear some positive/negative comment of why chosing a configuration type instead of another.

It seems to me that putting all of the configuration in the Environment variable is harder work but most secure (server breakdown vs table corruption/database error...)

Let's have some comments

Answer this question

Configuration Manager - which configuration type to chose ?

Answer this question