SharePoint List Source Error at data flow task [1]

Feb 17, 2014 at 1:36 AM
Edited Feb 17, 2014 at 1:40 AM

I'm a newbie in using SharePoint Lists Source and Destination in SSIS, so I hope you can help me with this error:

Error at Data Flow Task [SharePoint List Source [1]]:
Microsoft.Samples.SqlServer.SSIS.SharePointUtility.SharePointUnhandledException: Unhandled SharePoint Exception ---> System.ServiceModel.FaultException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.

I've read the same error somewhere, and it says it is a permissions error. I've checked that I have 'Full control, Limited Access' permission in the target SharePoint List.

I'm wondering if that error really is a permission error and do I have to have a 'Full Control' permission, instead of 'Full Control, Limited Access.' The error message was really vague. Hope you can help.

Thanks :)
Feb 18, 2014 at 1:29 AM
Found out that this is not a permissions error. Tried to ETL other Lists and all worked well except for this lone list.

Any thoughts?

Thanks :)
Feb 18, 2014 at 2:36 AM
Turns out, it was a SiteName mistake. The list name in the web portal is different from the actual name of the list. Thanks. :) Rookie mistake.
Mar 24, 2014 at 10:25 AM
Huge thank you for posting the solution !
Saved so much time...