Hi @Dyanna Hess-Miller ,
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.