Post reply

Sharepoint connection error

  • March 25, 2013 at 1:16 pm

    #275555

    Hi

    Iam trying to access Sharepoint data from SSIS. Iam not able to use the sharepoint adapters because I don't have enough privileges to install on my client machine.

    I found online that we can use following connection string

    Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes;

    DATABASE=http://sharepoint.yourdomain.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};

    but Iam not sure how to use it in OLEdb

    Please provide me assistance.

  • March 26, 2013 at 6:11 am

    #1600740

    demin99 (3/25/2013)

    Hi

    Iam trying to access Sharepoint data from SSIS. Iam not able to use the sharepoint adapters because I don't have enough privileges to install on my client machine.

    I found online that we can use following connection string

    Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes;

    DATABASE=http://sharepoint.yourdomain.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};

    but Iam not sure how to use it in OLEdb

    It sounds like the solution is to talk with your IT department and get them to install the SSIS SharePoint components. It'll probably be less hassle in the long run than doing the end run around them.

    http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

    Rob

Viewing 2 posts - 1 through 1 (of 1 total)

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