4

I want to make my SSIS project can be configure through project parameters. So I use project parameters to store connection strings. But the connection string which I copied from the mysql connection manager not working. After I assign the parameter value which I copied from the connection manager it self, to connection manager by expression, It says:

An error has occurred while connecting MySQL Server: Could not create a managed connection manager

How to fix this? I think this is a problem about connection string.

Hadi
1,22211 silver badges19 bronze badges
asked May 31, 2017 at 3:58
2
  • 2
    Can you post the connection string that is being derived? Commented May 31, 2017 at 5:11
  • Start by hard-coding the connection string. If it works hard-coded, then the problem isn't the connection string, but something with how you're managing the parameters. Commented May 31, 2017 at 14:16

1 Answer 1

2

There are many things that can causes this issue:

  1. You are running under 64Bit mode

in the project properties window, go to Debugging tab, and set Run64BitRuntime as false. and try again.

  1. If SSIS Server and DEV Computer have different Connector/.Net Versions

This will occur after deployment

  1. You are missing the provider in the connectionstring

You have to add ;Provider=MySQLProv or ;Provider=MSDASQL or other provider name (if you are not using these providers) to the connection string

References

answered Jun 5, 2017 at 12:16

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.