Hello,
I am trying to extract an .mpp file from a SharePoint Document folder . I'm able to use the OData Source to connect to SharePoint to see the lists but have no clue how to get to the files.
Any assistance would be appreciated.
Thanks
Dyanna
Hello,
I am trying to extract an .mpp file from a SharePoint Document folder . I'm able to use the OData Source to connect to SharePoint to see the lists but have no clue how to get to the files.
Any assistance would be appreciated.
Thanks
Dyanna
1.Drag-drop a Data Flow Task from the SSIS Toolbox on to the control flow design surface of your SSIS package.
2.Click the Data Flow tab, or double-click on the Data Flow Task to open the Data Flow design surface.
3.Drag-drop OData Source from the Common group in the SSIS Toolbox.
4.Double-click the OData Source component to launch the OData Source Editor dialog box.
5.Click New... to add a new OData Connection Manager.
6.Enter the OData service URL for Service document location. This URL can be the URL to the service document, or to a specific feed or entity. For the purpose of this tutorial, enter the URL to the service document: https://services.odata.org/V3/Northwind/Northwind.svc/.
7.Confirm that Windows Authentication is selected for the authentication to use to access the OData Service. Windows Authentication is selected by default.
8.Click Test Connection to test the connection, and click OK to finish creating an instance of OData Connection Manager.
9.In the OData Source Editor Dialog Box, confirm that Collection is selected for Use collection on resource path option.
10.From the Collection drop-down list, select Employees.
11.Enter any additional OData query options or filters for Query Options. For example, $orderby=CompanyName&$top=100. For the purpose of this tutorial, enter $top=5.
12.Click Preview to preview the data.
13.Click Columns in the left navigation pane to switch to the Columns page.
14.Select EmployeeID, FirstName, and LastName from Available External Columns by checking the check boxes.
15.Click OK to close the OData Source Editor dialog box.
Hope the following links will be helpful:
OData Source
Tutorial: Using the OData Source
How to configure OData SSIS Connection for SharePoint Online
Best Regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thank you. However, I can connect to the SharePoint list but I can't seem to extract an Ms Project attachement.
Hi Dyanna,
I would recommend you check the commercial COZYROC SharePoint adapters. You can download files from SharePoint using COZYROC File Transfer Task.
5 people are following this question.
SharePoint Online-Reading/Access Lists-Using SSIS -OData Connection- Error 401 Unauthorized
Sharepoint client 'List' no extension method 'Items'
PnP.Framwork for SSIS Script Task
Export from SSIS to Sharepoint list file using Visual Studio
SSID - OData connection to SharePoint Online failing at Data Conversion/Validate stage