Partager via

SSIS Tips Tricks and Best Practices: SSIS Operational and Tuning Guide

  • Article

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.