Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS

Posted by on Nov 11, 2010 in ETL, SQL Server, SSIS | No Comments

There are lots of links which described how to UPSERT( Update / Insert ) between two SQL Server tables. which mostly used Lookup Transform with OLEDB Command, like this:http://www.insideit.fr/post/2010/06/17/Lookup-simple-sur-SSIS But when you work with MySQL there is a limitation, you can not use OLEDB Connections, you can use ODBC or ADO.NET Connectors from .NET to ...

Read More