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 ...