Errors using SharePoint List Source within SSIS on SQL 2008 R2
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
November 10th, 2011 1:30pm

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
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2011 2:54pm

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
November 10th, 2011 2:59pm

Are you missing any Service Packs? Check if ShapePoint adapter is entitled for any updates.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2011 3:02pm

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
November 10th, 2011 4:02pm

Service packs are up to date and the same issue is persisting.Donald R. Landry
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2011 3:24pm

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.
November 25th, 2011 12:09am

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
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2011 6:31am

I sure would love some guidiance on tieing those credentials to a proxy account. I think I am having the same issue as you.
February 8th, 2012 12:56pm

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
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2012 4:56pm

Yanli, Sorry I haven't responded to this post just saw it today. I will post some instructions tomorrow.Donald R. Landry
May 15th, 2012 7:54pm

Yanli, When you created your SSIS package, add a SP connection manager by right-clicking the Connection Managers section and selecting [New Connection]. Select SPCRED from the list and click Add. Take default settings and click OK. When you use SP List Source or SP List Destination, add this manager in the Connection Manager column.
Free Windows Admin Tool Kit Click here and download it now
July 10th, 2012 6:24pm

Hi, We are also getting the same runtime connection error after upgrading to the 64-bit adaptor- can someone confirm that "tie credentials to a proxy account" is the solution, and advise how this is done? 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) Thanks MattF    
October 11th, 2012 1:28am

Hi, We are also getting the runtime connection error after upgrading to the 64-bit adaptor- can someone confirm that "tie credentials to a proxy account" is the solution, and advise how this is done? Thanks, MattMattF
Free Windows Admin Tool Kit Click here and download it now
October 11th, 2012 1:34am

You need to tell 1st what connection error is 1st MattArthur My Blog
October 11th, 2012 10:05am

Hi, The error does not occur in design mode - but when deploying the SSIS package to a server it fails validation. The SPCRED connection is configured to use the credentials of the executing process. We have confirmed that those credentials have full control over the destination sharepoint list. ThanksMattF
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2012 8:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics