Skip to Main Content
Pro SQL Server 2012 Integration Services
book

Pro SQL Server 2012 Integration Services

by Francis Rodrigues, Michael Coles, David Dye
June 2012
Intermediate to advanced content levelIntermediate to advanced
636 pages
14h 42m
English
Apress
Content preview from Pro SQL Server 2012 Integration Services

C H A P T E R  4

Connection Managers

Eventually everything connects—people, ideas, objects. The quality of the connections is the key to quality per se.

-American designer Charles Eames

SSIS uses connection managers to encapsulate, manage, and abstract away physical data stores. Connection managers allow you to read from, and write to, nearly any data store for which you have drivers and access. You can use connection managers to pull data from flat files, databases, or Excel spreadsheets and push data to databases, custom file formats, or web sites, for instance. In this chapter, you’ll start by looking at some of the most commonly used connection managers and move on to the more advanced, and less commonly used, connection managers SSIS ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server® 2012 Integration Services

Microsoft® SQL Server® 2012 Integration Services

Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam
Microsoft® SQL Server 2012 Unleashed

Microsoft® SQL Server 2012 Unleashed

Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Pro SQL Server 2012 BI Solutions

Pro SQL Server 2012 BI Solutions

Randal Root, Caryn Mason

Publisher Resources

ISBN: 9781430236924Purchase book