• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 989
  • Last Modified:

Integration Services from Mysql database

Hi experts, i need an example about
How to connect to Integration Services from Mysql database?
0
enrique_aeo
Asked:
enrique_aeo
  • 4
  • 4
1 Solution
 
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now