Commit after every N rows

• marcmax5

  Valued Member

  Points: 62

  More actions

  August 11, 2003 at 5:20 am

  #106793

  How I can make a commit after every N rows in a TDT?

  I need to import more than 14 millions registers and I want commit for each 5000 registries, for example.

  Thanks,

• mdaniel

  SSCarpal Tunnel

  Points: 4616

  More actions

  August 11, 2003 at 1:31 pm

  #469471

  Right-click on the TDT, go to properties, options tab, in the field "Insert batch size" enter the number of rows you want.

  Keep in mind that if the step fails it will rollback the last batch, not all the data.

• marcmax5

  Valued Member

  Points: 62

  More actions

  August 12, 2003 at 9:22 am

  #469597

  Milton,

  Its run fine! On the other hand, I like the behavior of the Rollback because if a batch fails, it doesn't interrupt the others.

  Thus I do not need to repeat the complete process because few baches have failed.

  Thank you very much,

  Marc