Destination (OLE DB) has two table with existing data. (table1 : Person with Bonus and Table2: Person without bonus)
The requirement is i want to insert the data from Excel source to these above table (OLE DB) Destination,
Before inserting i want to check if the data (Specifically person Id) which i'm gonna insert is already exists or not,
If Exists (Person), then i should not insert the duplicate data
If Exists (personId)but there is some updation , then i should update the particular record.
Please help on this. how to perform the above funtionalilty.
Below is the data flow my package
Excel Source (3 files) to UNION all task(To union all the 3 files data) to Sort Task(To sort the data ascendingly) to Aggregate ( Sum the metric values using group by person Id)
To Conditional Split( Perons Id with Bonus and Person Id without Bonus) to Ole db Destination.