For data interchange with MySQL there are two options one of which can be accessed in the connection wizards of SQL Server Integration Services assuming you have installed the programs. The other can be used to set up a ODBC DSN as described further down. The two connection options are:
- MySQL Connector/ODBC 5.1
- Connector/Net 5.2 New versions 6.0 & 6.1
this article brought to you by PACKT PUBLISHING.
MySQL Data Transfer using Sql Server Integration Services (SSIS)
Pick up the mechanics of working with SQL Server Integration 2005 under 10 days reading my no brainer book on SQL Server Integration Serivces.
No comments:
Post a Comment