Incremental loading a fact table

• come.on.mamu

  SSC Journeyman

  Points: 87

  More actions

  June 28, 2011 at 11:47 am

  #240049

  Hi All,

  I'm new to SSIS, I'm trying to load a fact table of around 50 million records using SSIS 2008. I could able to dump for the first time but can anyone please help me with a example/steps for incremental load. The source table has timestamp column and on that basis i want do incremental load.

  I did some research but i could not find the step by step process/example.

  thanks in advance,

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 28, 2011 at 12:46 pm

  #1345424

  Try the following URL which has some links to articles that may be of help to you.

  http://social.msdn.microsoft.com/Forums/en-NZ/sqlintegrationservices/thread/a9a48b4e-875b-4d32-b2b0-49e8f71e5a8a

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/