The remote server returned an error 403 forbidden using oData source to read from SharePoint 2019 on-premise
I have migrated SSIS packages from SQL Server 2012 to 2019 but once I open them in Visual Studio 2019 I could not get the Sharepoint List source component working. Online article suggests that I should use oData source. This package reads SharePoint 2019 lists and dumps data into SQL server.
I tried configuring oData but being first timer. I do not know the correct config. SharePoint Server 2019, Visual Studio 2019, SQL server 2019
Basically, I need to replace SharePoint list source component with similar component to make the packages work again.
It seems there might be a problem when working with Resource Paths. Can you try and use collections and use query options to manipulate your data and see if it works?
You can refer to the following documentation:
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- unpivot with different destination columns in SSIS Dataflow
- SSIS package shows blank screen in design mode
- Add SSIS to existing SQL Server instance
- Appending Header Record in Flat file SSIS
- Project consistency check failed. has a different ProtectionLevel than the project
- How to debug SSIS package in SQL Server Management Studio 2017?
- ORA-01422 error thrown when executing a stored procedure from SSIS script task, however it executes successfully when run from SQL Developer
- SSIS - The process cannot access the file because it is being used by another process
- What are the possibilities to call APIs in SSIS (Microsoft SQL Server Integration Services)?
- Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
- Specified provider is not supported IBMDA400
- SSIS Excel Connection Manager using Expression fail : "Cannot update. Database or object is read only"
- Connection failure running SSIS package from web service
- no leading zero in hours h:mm:ss time format to convert to seconds in a derived column in SSIS
- How do I avoid the SSIS error "Unable to determine if the owner (MyOwner) of job MyJob has server access"
- How to parameterize a custom SSIS component
- SSIS Execute SQL Task SQL Command Issue
- Why is my SSIS toolbox empty in Visual Studio 2019 community?
- SSIS job step fail : Not using SSL certificate but getting error
- Why won't Windows 11 allow an Administrator to run gacutil.exe?
- Where are SSIS Packages Saved?
- How to change "DestinationName" property of UNION ALL Transformation in SSIS
- Difference between .NET, OLEDB, and Native Providers in SSIS
- How do I work around the "The process cannot access the file .ISPAC because it is being used by another process" error?
- Sql Server SSIS package Flat File Destination file name pattern (date, time or similar)?
- Yesterday's date in SSIS package setting in variable through expression
- Wrong error in SSIS - [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset"
- Why do I get the error: "cannot communicate with the debug host process" when attempting to execute an SSIS package?