CONDITIONALLY INSERT OR UPDATE (UPSERT) DATA IN SSIS
There are two ways to conditionally insert or update data in SQL Server and Oracle in SSIS.
1) Spending tons of time building logic to detect row changes and using slower row-by-row components or separate SQL statements.
2) Use the easy Task Factory Upsert Destination written specifically for performance and easy development time. The component can be configured in just seconds and it can handle many more scenarios like looking for row differences or logging the number of inserts and updates to a variable.