How to update the records usnig CozyRoc's Table Difference component?

Question

Hi Friends,

    I am using the table difference component to update some records between two tables.But when it finds some records, which is existing in both source and destination tables, it is supposed to be updated if there is any change. but it tries to insert as a new record instead of updating. Where am i doing mistake? what is the condition i should give to update the existing records? 

Any suggestion would be really appreciated...

Answer 1

You could contact the CozyRoc's developers:
http://www.cozyroc.com/contact
http://social.msdn.microsoft.com/profile/cozyroc/?ws=usercard-mini

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Answer 2

Hi Prakash,

Make sure both the old and new input use the same sort order. Otherwise the component will not be able to do proper matching.

---

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Answer 3

Hi Prakash,

Make sure both the old and new input use the same sort order. Otherwise the component will not be able to do proper matching.

---

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Yeah...Do we need to stick only with OLEDB command component for updating any records...? it will not generate the update command itself right..? like SCD?

Apart from that, i feel this table difference is a very good component..its performance is 200% better than Microsoft SCD...

Thanks CozyRoc..

Answer 4

Hi Prakash,

OLEDB Destination task is used whenever the filtered rows are to be stored in new Data table and OLEDB Command task can be used whenever same data source is to be updated using suitable query.

---

Rajkumar

Answer 5

Prakash,

For the best performance I would recommend you setup a staging table where you insert the updated rows using the fast OLE DB Destination component. After your data flow finishes executing, transfer the updated rows from the staging table into the destination table using SQL command.

---

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Answer 6

Thanks Raj

Answer 7

Prakash,

For the best performance I would recommend you setup a staging table where you insert the updated rows using the fast OLE DB Destination component. After your data flow finishes executing, transfer the updated rows from the staging table into the destination table using SQL command.

---

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Ok Buddy, let me try with that..