SSIS : Connecting SharePoint Site through OData Source

kkran 831 Reputation points
2023-07-13T00:04:27.4866667+00:00

Hi All - I am connecting to a SharePoint site and i have edited the site at end like below and at the end i have added _vti__bin/List.svc

also i am able to access the sharepoint site through my account. When i selected the Odata source and passed the below url and its giving me below error :

Also i have downloaded/ installed : sharepointclientcomponents_16-6518-1200_x64-en-us as well.

I tried with Online services option as well and its giving me a component error :
User's image

User's image

Could you please help with this ?
https://sharepointxyz.com/sites/_vti_bin/List.svc

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,302 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,191 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,415 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,765 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 30,881 Reputation points
    2023-07-13T01:52:13.6766667+00:00

    Hi @kkran,

    As said there Connecting to SharePoint Lists with SSIS.

    Could not load file or assembly ‘Microsoft.SharePoint.Client.Runtime, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies. The system cannot find the file specified.

    I discovered this error on recent versions of SSIS, using both Visual Studio 2017 (SSDT) and Visual Studio 2019. As it turns out, the online version of SharePoint requires a specific version of the assembly Microsoft.SharePoint.Client.Runtime. This runtime requires a separate download and install. As of this writing, the required version is 15.0 (the same version associated with SharePoint 2013), which can be downloaded here.

    You may have a double check.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

  2. pankaj (ZappySys Team) 0 Reputation points
    2024-02-13T12:04:32.9166667+00:00

    Hi,

    ZappySys SharePoint Online Connector offers comprehensive read/write capabilities directly within your application, supporting various platforms such as Microsoft SQL, Oracle, Excel, Power BI, and more. Access, write, and delete SharePoint data effortlessly with just a few clicks!

    Here you can learn more about the ZappySys SharePoint Connector for SSIS: https://zappysys.com/api/integration-hub/sharepoint-connector/ssis

    Furthermore, Using the ZappySys SSIS JSON/XML Source external component, connecting to SharePoint is simplified.

    Please refer to this article for detailed instructions on how to establish the connection: https://zappysys.com/blog/sharepoint-365-rest-api-ssis-read-list-write-create/

    0 comments No comments