A number of the SSIS MVPs were asked to contribute a white paper to MSDN a few months ago, and those articles were published recently. You’ll notice a common thread in most of the topics:
- Considerations for High Volume ETL Using SQL Server Integration Services by Pat Martin
- Reusing Connections with Data Sources and Configurations by Matthew Roche
- Defining a Configuration Approach for Integration Services Packages by John Welch
- Best Practices for Integration Services Configurations by Jamie Thomson
- Understanding Integration Services Package Configurations by Rafael Salas (coming soon)
They are all great articles, and well worth reading.
Judging by the volume of questions related to configurations on the MSDN Forums, they are one of the more confusing features of SSIS. While there is some overlap in the articles on configurations, there’s valuable information that is unique to each, and will help give you a more rounded view of how to use them. As there are a lot of options and tradeoffs with configurations, it’s no surprise that everyone uses them slightly differently.
I hope the articles are valuable. Please leave comments if you have an approach to configurations that works well for you.