How to Check Whether the incoming Data is present or not in the Table?

Question

How to Check Whether the incoming Data is present or not in the Table?

rijosh2josh

SSC-Addicted

Points: 443
More actions
December 13, 2007 at 5:04 am

#184996

Hi,
I have some records that is getting from a Xml file. I just want to know is thr any Task that can be used for checking the incoming data from the xml with table. and also if present i want to go for an Update else insert.
please can any one help me out????????

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

scb SSCommitted Points: 1859 More actions · Answer 1

You want to check out the lookup transformation. See an example here : http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx

Gogula G. Aryalingam SSCrazy Points: 2688 More actions · Answer 2

Hi,

You could also use the Slowly Changing Dimension task for this purpose.

Cheers

cbehrens SSC Rookie Points: 49 More actions · Answer 3

Both the lookup and slowly changing dimensions are good approaches. A third approach would be to use your destination as a data source, and then outer join the tables together. Then, you split the resultset on the basis of the nulls which indicate the presence or absence, and work on those streams as INSERT or UPDATEs.