Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Wednesday, December 10, 2008 4:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 07, 2013 12:14 AM
Points: 14, Visits: 81
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.
Post #616841
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse