SharePoint List Adapter on SP 2013 and SQL 2012 Execution Failure

May 7, 2013 at 10:42 PM
Edited May 7, 2013 at 10:46 PM
When executing the SSIS package from SQL 2012 Management Studio I get the following error: "...sharepoint credential is not recognized as a valid connection manager type..."

We have packages running successfully on SQL 2008R2 using Custom Credentials (domain) and setting ProtectionLevel to EncryptAllWithPassword

SQL 2012 Setup:
  • SharePointListAdaptersSetup-Beta-2012-01-28.msi installed on the SQL 2012 server
  • VS 2012 with SQL Data Tools also installed on SQL server (for issue resolution)
  • Package built with VS 2012 with SharePoint List Source adapter (simple SP 2013 list)
  • Package executes inside VS 2012 (on the SQL Server) w/o issues
  • Deploy using VS to SSIS Catalog
  • Errors during manual execution of the Package.dtsx
  • Verified SharePointListAdapters.dll in C:\Program Files (x86)\Microsoft SQL Server\110\DTS\PipelineComponents
  • Verified SharePointUtility in GAC
On SharePoint 2013:
  • Everyone has Full Access rights
  • The service account we use for Agent job proxy has Full Access rights
Also tried:
  • Using Credentials of Existing Process and a scheduled Job with Proxy
  • Using Custom Credentials (domain) and setting ProtectionLevel to EncryptAllWithPassword
Any help will be greatly appreciated!