Changing Timeout Settings In SharePoint List Adapter (In 2005 Version of List Adapter)

Mar 31, 2010 at 9:03 PM


We have a project that uses SSIS in SQL Server 2005 and thus uses the 2005 Version of the SharePoint List Adapters, however we need to extend the timeout settings past the default 60 seconds and do not know of a way to do this.  Is this possible and if so how could we do this?

Jul 14, 2010 at 10:12 PM
Edited Jul 14, 2010 at 10:14 PM

No there isn't a way to do that modification that I know of. In the debug mode of SSIS, run your project & find the component that is timing out. If it the component is either a SharePoint List Destination or SharePoint List Source (stuff from this codeplex project), change their property of Batch Size to 1 (a "worst case") and see if you still get the issue. I find that SPList updates take a good amount of time, so find a batch size that works by experimenting.



Aug 3, 2010 at 7:42 AM

Grab the beta one - that should have it pretty much unrestricted on all timeouts and wcf related constraints.