C H A P T E R 14
Heterogeneous Sources and Destinations
We want to further eliminate friction among heterogeneous architectures and applications without compromising their distinctive underlying capabilities.
—Microsoft cofounder Bill Gates
One of the key elements of a data integration tool is the ability to handle disparate sources and destinations. SQL Server Integration Services 2011 allows you to extract from any storage method and load data into just as many data storage systems. The toolset provided by Integration Services truly attempts to achieve the goal outlined by Bill Gates to allow various systems to mesh well together. As discussed in previous chapters, data integrity is a key element to success of integration projects, and SSIS ...