O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with database connections in Data Flow

In this recipe, we will explore the OLE DB Source and Destination, ADO.NET Source and Destination, and SQL Server Destination. These are the most common components used to move data from sources to destinations.

All the database connections provide a way to connect to the underlying database which can range from DB2 database to Oracle and MS SQL Server databases. For some of the databases we may need to install the Data Provider, but after installing the Data Provider we can use sources/destinations to connect to the underlying database.

In this recipe, different database sources and destinations will be explored and their pros and cons in different scenarios will be considered.

In this recipe, we will ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required