Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Sharepoint List Adapters x86 and x64

Answered Sharepoint List Adapters x86 and x64

  • Wednesday, February 20, 2013 11:01 AM
     
     
    Sign In to Vote
    0

    I have a ssis package developed on my x86 machine using the codeplex sharepoint list source adapter. 

    I need to deploy the package to a x64 server for ongoing production use.  If I just copy the dtsx file to the server it fails to run (as a SQL Agent job) with the following error:

    Code: 0xC0014005     Source:       Description: The connection type "SPCRED" specified for connection manager "SharePoint Credential" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.  End Error  Error: 2013-02-20 10:00:10.60     Code: 0xC0010018     Source:       Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="link removed">  <DTS:Property DTS:Name="DelayValidation">0</DTS:Property>  <DTS:Property DTS:Name="ObjectName">SharePoint Credential</DTS:Property>  <DTS:Property DTS:Name="DTSID">{3B6C13BA-92D0-4FF3-8F3" from node "DTS:ConnectionManager".  End Error  Could not load pack...  The package could not be lo...  The step failed.

    What do I need to do to successfully deploy to an x64 server?

     

All Replies