Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

Take a look at the merge keyword. What I'd suggest is you load all your data into a temporary table (clear this between each load), then import all the server from the temporary table to your main table.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.