Início > Configuration Files, Packages > Why Use Config Files?

Why Use Config Files?

You have created 10 packages in BIDS on your Development laptop and now you need to deploy them to your development server. From there they will be deployed to QA and then on to Production. Your connection managers currently point to the localhost on your machine. You could deploy them to the first server then go into each package and point all the connection managers to the data source and destinations on that new server. Depending on the number of packages and connections this could take some time. You would then have to repeat it each time you move these packages to a new server. You may ask is there a better way?

This is where configuration files can make your life easier. Configuration files allow you to set properties for a package that will be saved outside of BIDS. You are able to save values for all the properties of the package such as connection managers, variables, task properties, just about any property. When the package is run the system will check for the configuration files and will replace the values listed in the package with those in the configuration file then run. If it cannot find the configuration file it responds differently depending on the version of SQL Server. In SQL Server 2005 the package will fail due to error if it cannot find the configuration files. In SQL Server 2008 the system will try using the default settings in the package. If they work the package will not fail.

If you set up a configuration file for each of your connections you can change the server in each of your configuration files when you move packages. You will want to move the configuration files along with the packages. If multiple packages use the same connection they can use the same configuration file which would cut down on the number of configuration files you need and number of places you would need to make a change.

  1. Ainda sem comentários.
  1. No trackbacks yet.

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da

Está a comentar usando a sua conta Terminar Sessão /  Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão /  Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão /  Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão /  Alterar )


Connecting to %s

%d bloggers like this: