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)

  • October 27, 2015 at 10:09 am

    #1835840

    Replying even though it is an old post .

    I too faced a similar issue and tried to remove unwanted columns etc m, but it dint work.

    The Issue was that for some columns the heading name displayed in share-point and SSIS was slightly different from the name that has to be used for CAML Query.

    You can dowload the CAML Query helper @ https://spcamlqueryhelper.codeplex.com/ , Compare the column name and build/Test your query in it.

    Eg : Field Name in Sharepoint : Building Name

    Field Name to be used in CAML Query was : <FieldRef Name="Building_x0020_Name" />