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)

  • May 5, 2014 at 12:26 am

    #1710636

    montu.saurabh (5/4/2014)

    I am also facing the same problem and it is not resolved by running with 32bit. Also I am fetching only one column. Please suggest.

    Which version of SSIS are you running? If SSIS 2012 or 2014, you can use the new OData Source[/url]. It works pretty great and you can easily select one column using the query parameters.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP