having a problem with ssis data flow

I'm trying to export data from MSSQL into MYSQL using SSIS.
I started off by making ADO.NET connections, one for MSSQL and another for MYSQL.

Then I added a 'data flow task' to my working area.
Then the steps say to select ADO.NET source and ADO.NET destionation.
I do not have those options in my toolbox. I only have OLE DB source and destination. If I choose that, I can only view the SQL connections and not the MYSQL.

Where can I find the ADO.nET souce tool?
rivkamakAsked:
Who is Participating?
 
Christopher GordonSenior Developer AnalystCommented:
The ADO.NET task is visible in the "Data Flow Sources" section of the toolbox when you are in the DataFlow section of the SSIS package.  You can double click on your Data Flow task to access this "part" of the package.  There is also a tab near the top of the Package called "Data Flow".  You can access it this way as well.

Make sure you have the MySQL ADO.NET connector installed as well.
http://dev.mysql.com/downloads/connector/net/6.0.html
0
 
rivkamakAuthor Commented:
I think I have the connector installed. I am able to set up a new ADO.NET connection in the connections tab. But I don't see the ADO in the data flow section.

Should I try to reinstall the connector?
temp.bmp
0
Get your problem seen by more experts

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

 
Christopher GordonSenior Developer AnalystCommented:
Which version of SSIS are you running?  2005 or 2008?

Thanks
0
 
rivkamakAuthor Commented:
2005
0
 
Christopher GordonSenior Developer AnalystCommented:
That's your problem.  SSIS 2005 has something called "DataReader Source" which later became the ADO NET source.
0
 
rivkamakAuthor Commented:
How do I connect the data reader to my ado.net connection that I have on the bottom?
0
 
Christopher GordonSenior Developer AnalystCommented:
You should be able to double click on the Data Reader task to open the "Advanced Editor".  This should present you with a screen that has a grid with the second column being "Connection Manager" where you can select your ADO.NET connection.  It's been a while since I've used the "Data Reader" source.
0
 
rivkamakAuthor Commented:
Which fields am I supposed to change?
temp.bmp
0
 
Christopher GordonSenior Developer AnalystCommented:
Sorry, I don't remember to much about the DataReader destination.  I believe the DataReader destination only allows you to load data into memory, but again, it's been a while.

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.

All Courses

From novice to tech pro — start learning today.