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 create a table in the MySQL database and transfer its data into SQL Server database table.
Getting ready
To install MySQL on Windows, you need to download WampServer which is available at http://www.wampserver.com/en/download.php. Install the WampServer...
