• Sorry for leaving you hanging. I haven't had a chance to get back on to SSC in quite a while. Did you ever get a resolution to this? I'm not very familiar with the SharePoint lists or administering SharePoint, so I apologize for not being super helpful.

    Did you have anyone check the network between where the package is running compared to where the SP list is hosted?

    Try changing the batch file size to 1 so you can eliminate the batch size from timing out.

    This link here may get you in the right direction:

    http://dataqueen.unlimitedviz.com/2011/06/how-to-use-a-sharepoint-list-as-a-data-source-in-your-ssis-package/

    If not, you might be able to reach out to the author of that article to get some assistance.

    Cheers,

    Steve