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
and the next time the following data is coming into X
1,2,12-22-2010 3,4, 06-12-2011
so the X shall become,
can somebody please tell me how to handle the above situation using SSIS using different transformations and using pure sql?