Douglas Laudenschlager from the SSIS documentation team has posted an excellent article to his unofficial SSIS blog on how package configurations are applied in SQL Server 2005 and SQL Server 2008 Integration services. Check it out here.
I don’t often post on my blog simply to reference someone else’s original work, but I wanted to do it today because:
- Package configurations are a vitally important feature that are often misunderstood.
- The manner in which configurations are applied has changed between SQL Server 2005 and SQL Server 2008.
- These changes can cause changes in package behavior when executing packages with specific DTEXEC options
So if you are moving from SQL Server 2005 to SQL Server 2008, definitely be sure to read about these changes.