Incremental & Full Load plan?

• bluepaperbags

  SSCommitted

  Points: 1738

  More actions

  March 16, 2009 at 12:29 pm

  #207493

  Technology:

  SSIS 2008

  SQL Server 2008

  Oracle

  I need a good plan to stick together incremental load (Extract,Transform,Load) and full load. I have the incremental load working for now. I working on the full load at the moment. There are 35 tables and all of them have many fields and over 50 Million records. I was planning to load 3 tables per day. What are the things I have to be careful about? What could go wrong? Any better plan?

• Phil Parkin

  SSC Guru

  Points: 246979

  More actions

  March 16, 2009 at 7:18 pm

  #960726

  pleasehelpme (3/16/2009)

  ---

  Technology:

  ... Any better plan?

  Backup/Restore? What exactly do you mean by "full load"?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel