asked on

Integration Services from Mysql database

Hi experts, i need an example about
How to connect to Integration Services from Mysql database?

you need to download mysql .net connector first
from here:
http://dev.mysql.com/downloads/connector/net/

and then install it.
then create a SSIS package,
add a data flow task in it.
add a oledb data source and connect it to mysql

this is also helpful about how to connect from ssis to mysql:
http://blogs.msdn.com/mattm/archive/2008/03/03/connecting-to-mysql-from-ssis.aspx

enrique_aeo

ASKER

I have a big problem. The S.O is Windows Server 2003 R2 Enterprise x64 bits.

ASKER CERTIFIED SOLUTION

Reza Rad

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

enrique_aeo

ASKER

Got a machine with xp operating system in 32 bits. What I did was:
1. Install the mysql. Net connector
2. Create a project, but the list oledb I see none that are for MySQL, I am attaching images
connecMysql1.JPG
connecMysql2.JPG

enrique_aeo

ASKER

Install in 64 bits, but I have the same problem, ie not listed in oledb source for mySQL

enrique_aeo

ASKER

Find the driver on the list. But I can not connect, I get the following error: TITLE: Connection Manager
Test connection failed Because of an error in initializing provider. Unable to connect to Any of the specified MySQL hosts. I am attaching the image
connecMysql.JPG

Reza Rad

sorry, I said it wrong before,
you should add ADO.NET DATA SOURCE instead of oledb data source
and then you will see mysql connector in the list.

Reza Rad

did you set the correct PortNo in All tabl?