Package configurations in SQL Server Integration Services (SSIS) gives you a powerful tool to manage configuration data (server names, ip addresses, file shares, resource locations) and make them portable from environment to environment with small amounts of changes. Although there are several package configuration options in the SQL Server 2005/2008 arsenal, one of the best is creating a configurations database. This gives you the ability to…
- Include configuration data in your normal SQL backup routine by backing up the configuration database.
- More familiar for DBAs and Programmers. Use TSQL statements to update large amounts of configuration data quickly.
- Manage multiple configuration scenarios across production, test and development environments by having local configuration databases on each allowing you to seamlessly move packages from environment to environment.
Now that the benefits have been laid out and the overall benefits of having completely mobile platform to de Read more >>