I got 1 xml source and 1 sql DB table..
Eg: Contact table in xml contains
--
bbb@.yaho.com
aaa@.yahoo.com
ccc@.yahoo.com
then COntact table in SQL server contains
aaa@.yahoo.com
ccc@.yahoo.com
zzz@.yahoo.com
i want to compare the two table if got same value update the row..
how to compare it in SSIS
thx
Can you provide more details?
What would be the filed(s) to be compared and which the ones to be updated?
See if the 'Checking to see if a record exists and if so update else insert ' thread in the 1st page of this forum helps you.
|||
Contact1
--
email ID
abc@.yah.com
bbf@.ya.com
-
Contact2
-
email ID
abc@.yah.com
zzz@.yaho.com
i want to check whether email column in two table match or not?
if got matching case, update the ID column in table Contact 1 with ID in Contact2
(Expected result is abc@.yah.com matching only)
is it lookup component can compare two column from different table?
thx.
|||
toongyang wrote:
is it lookup component can compare two column from different table?
In certain way, yes.
The lookup transformation will allow you to join 2 tables based on a set of columns, in your case email field, then bring additional columns to the data pipeline from the lookup table. I recommend you to check Books on line.
Notice that lookup can only based in tables that comes from an OLE DB source. If this is a problem for you, you could have 2 source components and then use a merge join. Merge join requires the 2 data sets to be sorted.
No comments:
Post a Comment