Row ID TRUNCATION

Sep 3, 2010 at 8:07 AM

Hi,

I'm using SSIS solution to update SharePoint list every day (It is about 200 rows.) There are 3 steps:

  1. Download all data from the list
  2. Deletetion of all data in the list
  3. Insertion of new data from DB to the list

Every time the job executes, the SharePoint row ID is incremented. I'm affraid that one time it will reach the limit. Does anybody knows if it is possible to truncate this row ID of the list to go every time from 1?

I would appreciate any suggestions!

Thanks!

 

Mar 24, 2011 at 1:05 PM

I know having 2000 items in 2007 is a performance limit.  Don't know if the ID incrementing has a limit.

Why not replace the items with new data (i.e. do an modify not an add) and add or remove for those outside of the limit.

A bit more programming!

Coordinator
Aug 3, 2011 at 6:55 AM

Agreed- modify, do not dump and add.  A new documentation site for the adapters does call out a site that describes this.