Solved

having a problem with ssis data flow

Posted on 2011-09-09
10
233 Views
Last Modified: 2012-05-12
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?
0
Comment
Question by:rivkamak
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 14

Expert Comment

by:Christopher Gordon
ID: 36512329
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
 

Author Comment

by:rivkamak
ID: 36512500
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
 
LVL 14

Expert Comment

by:Christopher Gordon
ID: 36512523
Which version of SSIS are you running?  2005 or 2008?

Thanks
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:rivkamak
ID: 36512546
2005
0
 
LVL 14

Expert Comment

by:Christopher Gordon
ID: 36512567
That's your problem.  SSIS 2005 has something called "DataReader Source" which later became the ADO NET source.
0
 

Author Comment

by:rivkamak
ID: 36512654
How do I connect the data reader to my ado.net connection that I have on the bottom?
0
 
LVL 14

Expert Comment

by:Christopher Gordon
ID: 36512779
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
 

Author Comment

by:rivkamak
ID: 36512966
Which fields am I supposed to change?
temp.bmp
0
 
LVL 14

Expert Comment

by:Christopher Gordon
ID: 36513220
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
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 36513478
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question