Connection Managers

As data grow in random places, it’s the job of the information analyst to bring it all together to draw out pertinent information. The biggest problem of bringing together such data sets and merging them to a single storage location is how to handle different data sources, such as legacy mainframe systems, Oracle databases, flat files, Excel spreadsheets, Microsoft Access files, and so on. Connection managers provided in Integration Services come to the rescue. Connection managers are new features in SQL Server 2005 Integration Services.

In Chapter 2, you saw how connection managers deal with importing data. The components defined inside an Integration Services package require that physical connections be made to data stores ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.