Loading the Cloud

It is 2012 and cloud technology is becoming ubiquitous. As more applications are hosted in various cloud service providers, the desire to locate their associated data in the cloud increases. Thanks to forethought and good engineering, Microsoft SQL Server is well-positioned to assist. The user experience when interacting with Microsoft SQL Azure databases is nearly identical to interacting with local servers or servers on the enterprise network. Make no mistake, this is by design – and it is good design.

In this chapter, we will consider SSIS design patterns used to integrate data in the cloud. These patterns are ...

Get SQL Server 2012 Integration Services Design Patterns now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.