Yuni Widyaningtyas Yuni Widyaningtyas - 11 months ago 84
MySQL Question

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?

Answer Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download