Integration Services from Mysql database

Hi experts, i need an example about
How to connect to Integration Services from Mysql database?
enrique_aeoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Reza RadConsultant, TrainerCommented:
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

0
enrique_aeoAuthor Commented:
I have a big problem. The S.O is Windows Server 2003 R2 Enterprise x64 bits.
0
Reza RadConsultant, TrainerCommented:
did you tried to install .net connector on it?
maybe it work, sometimes 32bit applications run on 64x OS.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

enrique_aeoAuthor Commented:
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
0
enrique_aeoAuthor Commented:
Install in 64 bits, but I have the same problem, ie not listed in oledb source for mySQL
0
enrique_aeoAuthor Commented:
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
0
Reza RadConsultant, TrainerCommented:
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.
0
Reza RadConsultant, TrainerCommented:
did you set the correct PortNo in All tabl?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.