SSIS Tips Tricks and Best Practices: SSIS for Azure and Hybrid Data Movement

SSIS for Azure and Hybrid Data Movement

SQL Server Technical Article

Writer: Alexei Khalyako, Carla Sabotta, Daniel Sol, Silvano Coriani, Sreedhar Pelluru, Steve Howard

Technical Reviewer: David Pless

Published: December 2012

Applies to: SQL Server 2012

Summary: SQL Server Integration Services (SSIS) can be used effectively as a tool for moving data to and from Windows Azure 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 best practices for using SSIS for cloud sources and destinations and for project planning for SSIS projects to be used with Azure or hybrid data moves, and gives an example of maximizing performance on a hybrid move by scaling out the data movement.

To review the document, please download the SSIS for Azure and Hybrid Data Movement Word document.