Solved

SSIS MySQL .NET provider not listed

Posted on 2013-10-30
4
415 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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

707 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