data exists

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » data exists

data exists

Rate Topic

Display Mode

Topic Options

Author

Message

harri.reddy

Posted Wednesday, November 07, 2012 9:33 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346

hi

ia m getting data from 2 excel file ,that i need to merge and then load into destination table.

but before file load i need to 1 number from 1 file, if it is already exists in the database, i dont need to insert that rows,if not i need to insert

hwo to do using ssis

Post #1382057

Daniel Bowlin

Posted Wednesday, November 07, 2012 12:11 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:10 PM
Points: 2,673, Visits: 2,418

If you have some sort of ID column, use a lookup transform to lookup data that is already in your table and match it to the data coming in from Excel. Configure the lookup transform to ignore errors and then use the No Match precedence constraint to connect to your destination table.

Post #1382121

harri.reddy

Posted Thursday, November 08, 2012 8:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346

ok.

can i check in lookup with 2 column

for example productid and productname both should match .not OR.

Post #1382532

Phil Parkin

Posted Thursday, November 08, 2012 10:22 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:39 AM
Points: 4,247, Visits: 9,500

Yes.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1382616

« Prev Topic | Next Topic »

Permissions