This article aims at relaying the steps in integration between SQL Server and MySQL using SQL Server Integration Service 2005
Following are the steps for integration.
To connect MySQL from SQL Server Integration Service 2005 requires the installation of the correct MySQL ODBC Driver. You may find these drivers from the MySQL website http://www.mysql.com/downloads/connector/odbc/
After Installation you will find drivers installed in Control Panel -> Administrative Tools -> Data Sources (ODBC)
Creating SQL Server Connection Manager is easy. You can create SQL Server connection manager with OLE DBSQL Native Client and provide credentials.
For MySQL you need to create a ne.w ADO.Net Connection and select .Net Providers Odbc Data Provider from the list as outlined below,
Now you are ready with both connection managers.
Following is the code for script component which calls upsert stored procedures to insert/update record in the MySQL product table.
Now you are ready with package wich fetches data from SQL Server and inserts in MySQL Database.
Rishabh Software, a CMMI Level-3 technology company, focuses on cost-effective, qualitative and timely delivered Software Development, Business Process Outsourcing (BPO) and Engineering Services. Contact us today or call 1-877-RISHABH (1-877-747-4224)!