SSIS - Sharepoint list data transfer

Question

Is there a limit on the number of rows that can be transferred from a Oracle database(OLEDB source) to a sharepoint list using SSIS? I am getting exception after transferring 19000 records

Answer 1

First of all, I'm assuming you are using the API to store the information in SharePoint rather than a direct write to the SQL database. Any direct access to the database is unsupported.

To give a proper answer would require the details of the exception. However:

• Recommended number of items in a list is 2000
• Maximum number supported recommending the use of folders is 5 million

Performance reduces significantly beyond the 2000 mark. This may be what's causing the exceptions. There is information about this on TechNet, from Joel Oleson (formerly on the MS SharePoint team), and an MS whitepaper.

Another possible limit you're reaching is the maximum database size for a site collection, which is 200GB.