Understand how SSIS package configurations are applied

This week I'm cleaning up our BOL documentation about how SSIS package configurations are applied, and how the behavior has changed between SQL Server 2005 and SQL Server 2008 Integration Services. These changes affect what you can and can't do to change your design-time settings at run time. My cleanup was prompted, as is often the case, by a kick in the butt from Microsoft Support and its customers. I admit that it has taken me a while to figure out all the ifs, ands and buts. SQL Server 2008... [More]

New MSDN articles on Integration Services deployment and performance

The Microsoft MVPs and consultants who spend every day implementing real-world solutions with SQL Server Integration Services gain a wealth of practical knowledge that even the development team can't match. So we're very pleased to announce a first batch of articles in the MSDN Library from these experts, on the pressing issues of package deployment and performance. These aren't "buy our product" or "admire our benchmarks" whitepapers...these are bundles of best practices, what to do and what... [More]