Home Forums SQL Server 2005 SQL Server 2005 Integration Services Sharepoint List Source Error -A possible reason might be you are trying to retrieve too many items at a time (Batch size) RE: Sharepoint List Source Error -A possible reason might be you are trying to retrieve too many items at a time (Batch size)

  • September 15, 2014 at 4:03 pm

    #1745624

    any updates on this?

    I'm running an ETL pulling 3 lists each with multiple columns however one has many more fields than the other 2 and that's the one which is failing. All running in the same job and not running 32 bit mode, all unused columns are removed.

    I initially ran into problems with the fact that ssis determines meta data based on only a subset of rows so i ended up with columns that were too small, ive since increased those to nvarchar 4000 due to the fact that I don't know how big they could be. Also SSIS determined that some columns are ntext. So the buffer is quite large.

    The weird thing is that this runs fine on my workstation in SSDT but gets the "too many items" error when running on the 2012 server.

    I can modify the columns since I know some don't need to be that big, however I'd like to first get an idea of what the actual problem is.

    One thought was to pull in the data using 2 separate sources and grab half the columns from each and join them up but again would like to know the actual issue.

    thanks,

    Tom