SSIS Operational and Tuning Guide
SQL Server Technical Article
Writer: Alexei Khalyako, Carla Sabotta, Silvano Coriani, Sreedhar Pelluru, Steve Howard
Technical Reviewer: Cindy Gross, David Pless, Mark Simms, Daniel Sol
Published: December 2012
Applies to: SQL Server 2012; Windows Azure SQL Database
Summary: SQL Server Integration Services (SSIS) can be used effectively as a tool for moving data to and from Windows Azure (WA) SQL Database, as part of the total extract, transform, and load (ETL) solution and as part of the data movement solution. SSIS can be used effectively to move data between sources and destinations in the cloud, and in a hybrid scenario between the cloud and on-premise. This paper outlines SSIS best practices for cloud sources and destinations, discusses project planning for SSIS projects whether the project is all in the cloud or involves hybrid data moves, and walks through an example of maximizing performance on a hybrid move by scaling out the data movement.
To review the document, please download the SSIS Operational and Tuning Guide Word document.