Hello all, I need to load data from mysql in SSIS package. On test environment I used ODBC connector to mysql server and package works fine. But on production environment is different setting of MySQL (the SSH tunnel is used) and I can't setup connection. Connection in workbench is on following picture. ODBC definition accepts only one IP address. When I use the address of SSH the server checks credentials on another server, when I use server IP the result is "cannot connect to mysql ... (10060)". I've tried to use mysql connector/NET but i have the same problem. do you know, how right setup connection? I'll be appreciative of any useful information regards Petr

Hi Petr, The error message "Cannot connect to myql ...(10060)" is an error thrown by MySQL. It should be caused by the SSH is not configured correctly. Please re-configure the SSH to fix the issue. Besides, it is a MySQL question, I would suggest you posting in http://www.mysql.com If you have any more questions regarding SQL Server Integration Services(SSIS), please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Hi Jin Chen, thanks for answer. however it don't help me :-( I think it's partialy SSIS question because the connection is from intergration services and I looking for connection manager to mysql which allows me use this server directly (means allows me set the same connection parameters). Currently I do it really disgusting way: with masql tools I export data to file, then I upload file to SQL server ... but this is another fairytale :-) regards. Petr

Hi Petr, Where is the above dialog that you have posted screenshot for? Have you tried specifying 127.0.0.1 for the MySQL Hostname parameter ?SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Hi Petr, The question is a little confused. If you meant we got the error "Cannot connect to MySQL ...(10060)" from the Workbench, then the question is really a MySQL and SSH question. I can reproduce the issue you met. I used the following steps to solve the issue: Make sure the SSH server is running, and check the IP, port, usename and password of the SSH server. In Workbench, make sure the SSH hostname and port is correct. For example, I am using port 7777. So, the SSH hostname I used is <IP>:7777 Make sure the username and password is correct. Besides, you can try to use a simple password instead of a complex password to check if it works. If you meant we are not able to connect to MySQL via ODBC using Tcp/IP over SSH, it is due to we don't open a SSH connection to the server. To fix the issue, please: Install a SSH client. Configure the port forwarding. In ODBC connection, type the client's IP in the TCT/IP textbox. Here is a good article, which will help to understand the steps: http://realprogrammers.com/how_to/set_up_an_ssh_tunnel_with_putty.html If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT