terça-feira, 19 de novembro de 2013

MySQL / Integration Services

How could you use MySQL with Integration Services?

Step1
Download and install a suitable odbc connector to MySQL
http://dev.mysql.com/downloads/connector/odbc/
Be careful with the version.
If your version is 5.1.5, like mine you should download the odbc connector from here http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-5.1&v=5.1.5

Step2
Create a datasource.
Step3
With datasource created, go back do Integration Services and chose DataRead component.




Step4
Drop the DataReader on the Data Flow and chose one of the connections of connection manager.
You're done. You're ready to work with MySQL data.




Nenhum comentário:

Postar um comentário