Hello - I have to move significant amount of data from a MySQL server to SQL server 2008. The login to this MySQL database server is via SSH tunnel. I need help to figure out ways to create a connection for this in SSIS. I tried creating ODBC data source but it's failing to create successful connection. Does anyone has experience creating MySQL database connection over SSH tunnel in SSIS? Thanks, Amey

This is how you make an ODBC connection from Windows: http://dev.mysql.com/doc/refman/5.1/en/windows-and-ssh.htmlArthur My Blog

Thanks Arthur!Amey