Hi,
1)I am using a "Flat File source" for taking input from CSV file.
2)Using "Lookup" and "condition Split" control I am checking if the Id from CSV file is a new Id or an existing Id.
3) If there is a new Id , I am inserting the record using "SQL Server Destination"
4) If an Id from CSV file already exist in the database table, I have to update the row corresponding to the Id.
I have done the first 3 steps but I am struggling with the last one. Which control I should use as destination to update the database table.
Please help.