Solved

SSIS MySQL .NET provider not listed

Posted on 2013-10-30
4
405 Views
Last Modified: 2016-02-11
I have installed the MySQL connector.net 6.7.4 & the odbc 5.2.6 drivers for 32bit on my win 2k8 32bit server

But when I open SSIS and try to choose the MySQL .net provider from the list of .NET connections it is not in the list?

Any ideas?
0
Comment
Question by:BrianFord
[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
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 500 total points
ID: 39613248
Have you tried using an ODBC connector in SSIS? I've not used MySQL like this, but maybe going through the ODBC system to get to the MySQL part is the way to go.

hth

Mike
0
 

Author Comment

by:BrianFord
ID: 39613756
Yes, that's what I'm currently using but I'm trying to find out why the .NET provider is not available?

I have another BI server and the provider shows up fine on that one and I can see no difference in setup
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 39615603
Well, there must be a difference - it's a matter of discovering just what <grin>

Check your versions of .net. Maybe your connector needs a version that's installed on one machine and not on the other.

Also check the machine.config file, somewhere down there below \Windows\Microsoft.net\Framework and see if playing around with that helps - compare it with the one on the other machine (but make a backup first!!)

hth

Mike
0
 

Author Comment

by:BrianFord
ID: 39628285
Check it all, all looks the same other than the fasct that 1 is 32bt and the other is 64bit

But I have verified that the correct version of the drivers are installed
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

730 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