Creating an SSIS Data Source Connection to MySQL

Here’s how to create an SSIS data source connection to MySQL:
 
1.  Download and install the MySQL Connector ODBC 3.51.
2.  Create a new DSN through Windows Data Sources (ODBC)
3.  Create a new SSIS ADO.NET connection that uses the .NET ProvidersOdbc Data Provider based on the DSN name created in #2
4.  In your Data Flow, use a DataReader Source that uses the ADO.NET connection created in #3.
5.  Add a select statement to the SqlCommand property of the DataReader source that specifies the columns to extract from the table you need to read data from.
About these ads

3 Comments (+add yours?)

  1. Manoj
    Feb 25, 2009 @ 09:14:18

    It is working for MySQL to MS SQL, but i need opposite of it. Can you provide the procedure for Creating MySQL as a SSIS destination.

    Reply

  2. leamonjxl
    May 19, 2011 @ 01:30:00

    MS SQL to MySQL
    —Please. Thank You :)

    Reply

  3. export from Mssql to mysql
    Dec 31, 2013 @ 08:09:32

    Amazing! Its genuinely remarkable article, I have got much clear idea about from this piece of writing.

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: