Search code examples
mysqlsql-serverssismove

SSIS - Move data from SQL Server to MySQL

I have to move data from SQL Server to MySQL using SSIS. I've got this tutorial, but I couldn't find ODBC Destination in Visual Studio 2008. is there another way to move data from SQL Server to MySQL?

Solution

  • The ODBC destination was added in SQL 2012. Visual Studio 2008 (or really BIDS 2008) works with SQL Server 2008 and 2008 R2, which are prior versions.

    However, you can still do this in 2008 using and ODBC driver and the ADO.NET Destination. Read more about that here: https://blogs.msdn.microsoft.com/mattm/2008/03/04/connecting-to-mysql-from-ssis/

    m