CODEWITHSUNDEEP
.netssis
Athanasios Kataras
Athanasios Kataras

Reputation: 26450

SSIS: Error --> Could not create a managed connection manager (VS 2010 - AdoNet MySql)

I just upgraded my Connector/C# for Visual Studio and I get the error above. Everything seems fine, the preview queries work just fine in the package but upon execution this error occurs.

Anyone with the same problem in the past? There is a lot of speculation on 32/64 bit OSes, though MySQL official website states that even though the installer says x86, that means nothing (Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries.).

EDIT -> I tried connecting manually through an SSIS script to see if the coded exception provided more info. Unfortunatelly it provided even less

ConnectionManager connMan = Dts.Connections[7];
try
{
    connMan.AcquireConnection(Dts.Transaction);
}
catch (Exception ex)
{
    Dts.Events.FireError(-1, "Elt-Proc:", ex.Message, "", 0);
}

Upvotes: 1

Views: 9892

Answers (1)

Athanasios Kataras
Athanasios Kataras

Reputation: 26450

Found the answer:

Problem was with VS-2010, SSIS, and latest ADO .Net connector / MySQL For Visual studio.

I had installed the latest Connector/Net 6.7.4 and the MySQL for Visual Studio. I noticed that the version in the string at the connection properties was 6.6.5.

So I uninstalled the 6.7.4 version and re-installed the 6.6.5 version and worked like a charm.

I hope this will help others as well. It took way too much time for me to find out.

IMPORTANT: This error will also occur (on the server side) if SSIS Server and VISUAL STUDIO DEV Computer have different Connector/.Net Versions

Upvotes: 6

Related Questions