Hi, I'm getting the following error when attempting to access data from a SharePoint List using the SharePoint List Source. It fails on the SharePoint Credential connection even though when I go into the column mappings the SharePoint List fields come up. Has anyone seen this issue and what would the resolution be. Thanks for your help!!! Don Error at Data Flow Task [SSIS.Pipeline]: The "runtime connection "Sharepoint Credential Connection" (11)" in the connection manager collection, Connections, of "component "SharePoint List Source" (1)" does not have a value for the ID property. Verify that the ConnectionManagerID property of the runtime connection object has been set for the component. Error at Data Flow Task [SSIS.Pipeline]: component "SharePoint List Source" (1) failed validation and returned error code 0xC004801C. Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration) Donald R. Landry

Hi Donald, Is that happening when you run your package on the server (after it was deployed)? Thing is I suspect you use a config value [for credentials] that does not get picked up.Arthur My Blog

I haven't deployed anything yet just in Visual Studio trying to test it out and it kicks this error. All I'm trying to do is to copy the SharePoint list data to a sql table for reporting but when I run the first step SharePoint List Source I get the error. You'd think since it sees the SharePoint list values that it would work but its obviously trying to get into the content db and having issues.Donald R. Landry

Are you missing any Service Packs? Check if ShapePoint adapter is entitled for any updates.Arthur My Blog

I bet that is it I haven't updated these servers in a bit. They are due... I'll try that and see how it goes. ThanksDonald R. Landry

Service packs are up to date and the same issue is persisting.Donald R. Landry

Hi Donald R. Landry, Please refer to the following links: http://sqlsrvintegrationsrv.codeplex.com/workitem/16607 And please see more details about using SharePoint List as datasource in SSIS: http://dataqueen.unlimitedviz.com/2011/06/how-to-use-a-sharepoint-list-as-a-data-source-in-your-ssis-package/ If you have any question, please feel free to ask. Thanks, Eileen

Are you using a package you made from scratch since you installed the adapters? I have never seen that kind of error before. Try remaking a new package to see if it happens again.. otherwise, I've never heard about this and if it is consistent, I would like to know more.

I've figured this out. The problem was that it wasn't really clear in the instructions that you need to create credentials under the security tab within SQL Server and also tie those credentials to a proxy account. This is all needed in order to get the SharePoint connection maanger setup correctly. Also when you are in SSIS setting up the connection for the SharePoint Adapter when you select the advanced editor on the object it looks like the connection manager piece is greyed out but if you click on the connection you'll see the credential that you've created to make the connection manager work. For those of us that are newer to SSIS and have to play multiple roles so we're not exclusively doing SQL Server, BIDS and/or SSIS work all the time the instructions just didn't speak to the SQL Server Security setup that well. I will eventually add in step by step instructions on the security setup in this thread later this week Thanks everyone for your help with this issue!!Donald R. Landry

I sure would love some guidiance on tieing those credentials to a proxy account. I think I am having the same issue as you.

Hi Donald, I am having the same issue when loading data from SQL Server to a SharePoint 2007 list. Could you share how to tie credentials to a proxy account? The reply was 5 months old. I was wondering if you have posted the step by step instructions on the security setup anywhere in the internet. Thanks a lot! Yanli

Yanli, Sorry I haven't responded to this post just saw it today. I will post some instructions tomorrow.Donald R. Landry