In previous post I presented a way for UPSERT in MySQL with SSIS 2008, in this post I present another solution which is compatible with SSIS 2005 for UPSERT in MySQL Table.As previous post shows, the main problem is: There are lots of links which described how to UPSERT( Update / Insert ) between two Read more about Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS 2005[…]
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 about Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS[…]
suppose this scenario: you have a source table and a destination table, you want to transfer rows from source table to destination table, so you can use simple data flow with OLE DB source and OLE DB Destination. but problem hits when destination table has few rows inside, and there is Unique Constraint in ID Read more about How to handle Failed Rows in a Data Flow[…]