I have a table in SQL say 'X'(i primary key int,j int, dt datetime) and it contains some data. The initial load of data is fine but I am confused about how to handle the incremental data. i.e. suppose initially X contains some data

1,2, 12-22-2010

3,4, 06-12-2011

and the next time the following data is coming into X

1,2,12-22-2010 3,4, 06-12-2011

5,6, 07-01-2011

3,7, 10-10-2011

so the X shall become,

1,2, 12-22-2010

3,7, 10-10-2011

5,6, 07-01-2011

can somebody please tell me how to handle the above situation using SSIS using different transformations and using pure sql?