SPCRED Credential unavilable in SSIS

  • Hi,

    I am trying to deploy my SSIS packages with SharePoint source to a new server . I am getting an error : Failed to deploy the project. Fix the problems and try again later.:Unable to create the type with the name 'SPCRED'.

    When I try to download the SharePointList Adapter from the link below : I am not able to find it . Can anyone help where I can get to download it ?

    https://archive.codeplex.com/?p=sqlsrvintegrationsrv#DownloadId=44461

    Thanks,
    PSB

  • PSB - Wednesday, May 23, 2018 6:29 AM

    Hi,

    I am trying to deploy my SSIS packages with SharePoint source to a new server . I am getting an error : Failed to deploy the project. Fix the problems and try again later.:Unable to create the type with the name 'SPCRED'.

    When I try to download the SharePointList Adapter from the link below : I am not able to find it . Can anyone help where I can get to download it ?

    https://archive.codeplex.com/?p=sqlsrvintegrationsrv#DownloadId=44461

    Thanks,
    PSB

    Microsoft moved their stuff to GitHub. Try this link:
    https://github.com/chrisdee/Tools/tree/master/SharePoint/SharePointListAdapters

    Sue

  • Thanks. I was able to install the feature. However, I still don't see SPCRED in the connection manager and SharePoint List Destination and SharePoint List Source in the Data Flow tab after refreshing Toolbox . Is there anything else I need to do ?

  • PSB - Wednesday, May 23, 2018 7:13 AM

    Thanks. I was able to install the feature. However, I still don't see SPCRED in the connection manager and SharePoint List Destination and SharePoint List Source in the Data Flow tab after refreshing Toolbox . Is there anything else I need to do ?

    You used to have to close and re-open SSDT if you had it open while installing. Try giving that a shot.

    Sue

  • I tried that already without luck . SSIS Data Flow Items is also missing as seen from the screenshot . I am using VS 2017

  • PSB - Wednesday, May 23, 2018 8:07 AM

    I tried that already without luck . SSIS Data Flow Items is also missing as seen from the screenshot . I am using VS 2017

    Sorry...I think I messed that one up. You probably want to use this one instead:
    https://github.com/japj/sqlsrvintegrationsrv/tree/master/SharePointListAdapters

    Sue

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply