Comparison in SSIS while data transformation

Posted by Nishithraj under Sql Server on 2/25/2010 | Views : 1650 | Status : [Member] | Replies : 2
How do we compare the data in SSIS.

I have a flat file and I need to compare the data with a database of sqlserver and if there are existing records I need to update the data. Also I need to insert the new items.

How can we do this?

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan



Responses

Posted by: Vuyiswamb on: 2/25/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
There are many ways to do that. But as for me i will first take the data from the flat file and add it to a temp table and Compare the data and after that do the update. This can be done in one sp. you can just import the data into a temp as i said and call a sp to update and drop the table when you are done.



Thank you for posting at Dotnetfunda
[Administrator]

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nishithraj on: 2/25/2010 [Member] Bronze

Up
0
Down
Actually I thought the same way as you said. I have created a temporary table. But What will be the exact component of SSIS to use for checking the existing data?

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response