SharePoint List Adapter: Problem using SharePoint Credential Connection Manager with SSIS 2012

Aug 9, 2013 at 2:33 PM
Anyone know if the SharePoint Credential connection manager is working correctly with SSIS 2012? I have the updated version of the SharePoint List Adapter installed and have packages that work correctly when run in debug mode with the SharePoint Credential connection manager in place. However, when deployed and run on a server via SQL Agent jobs, the packages fail. If I remove the SharePoint Credential connection manager and just set the SharePoint List source or destination in my data flows to not use a connection manager at all, the packages appear to work fine. So it looks like the SharePoint Credential connection manager just doesn't work correctly -- maybe due to a 32-bit versus 64-bit issue of some type?

Anyone else seeing this behavior? TIA :-)

Dave F.