question

DyannaHessMiller-7433 avatar image
0 Votes"
DyannaHessMiller-7433 asked COZYROC Suspended answered

extracting .MPP files in Sharepoint using SSIS

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

office-sharepoint-onlinesql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered

Hi @DyannaHessMiller-7433,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DyannaHessMiller-7433 avatar image
0 Votes"
DyannaHessMiller-7433 answered

Thank you. However, I can connect to the SharePoint list but I can't seem to extract an Ms Project attachement.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

COZYROC avatar image
0 Votes"
COZYROC Suspended answered

Hi Dyanna,

I would recommend you check the commercial COZYROC SharePoint adapters. You can download files from SharePoint using COZYROC File Transfer Task.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.