2

What is the best way of loading a fact table incrementally using SSIS?

Gilbert Le Blanc
  • 50,182
  • 6
  • 67
  • 111
Queue
  • 321
  • 2
  • 3
  • 9

1 Answers1

2

Depends upon the schema of your source table. If you've an auto incremented ID, store it's value in a control table and do an import where ID > your last imported one. Same sort of thing for date columns store it in a control table and import where date > last imported date.

Depending on your version of SQL, you could also look into using change data capture (SQL2008), in which you can do things like give me all the changes since ? or give me the net effect.

SPE109
  • 2,911
  • 1
  • 19
  • 16