Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Insert or update depending on if new Id or the existing one. Expand / Collapse
Posted Wednesday, December 10, 2008 4:35 AM


Group: General Forum Members
Last Login: Monday, February 23, 2015 10:28 PM
Points: 14, Visits: 82

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.
Post #616841
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse