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:
- data conversion issue while executing a ssis package
- How to generate an Excel file from SQL table using SSIS?
- Empty path name is not legal - DTEXEC with Powershell
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- Error: The type of the value (DBNull) being assigned to variable "User:: differs from the current variable type (String)
- Project consistency check failed. has a different ProtectionLevel than the project
- Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications.Core, Version=10.0.0.0
- SQL Server Deployed SSIS package won't open files despite SA account having access to folder
- convert Excel Date Serial Number to Regular Date
- SSIS: How to parameterise foreach folder loop location from project.params value?
- visual studio 2019 open solution file incompatible
- Multiple outputs from SSIS Script
- SSIS The expression for variable 'Variable' failed evaluation. There was an error in the expression
- SSIS OLE DB Destination Editor - Create New Table not an option?
- SSIS - Can you use a parameterised query to populate a Lookup Transformation?
- Flattening a Recursive Hierarchy Into a Dimension with SSIS
- SSIS set result set from data flow to variable
- Connection Manager in SSIS task: Keyword not supported: 'ProviderName'
- Passing query results to variable in SSIS
- Controlling the flow in SSIS package based on a condition
- How to Query Integration Services Catalog
- Varchar to Date in SSIS
- varchar to date format in SSIS
- Refresh Excel using SSIS script task
- SSIS - out of memory error again
- SSIS - the value cannot be converted because of a potential loss of data
- Conditional split based on array variable
- SSIS tasks are getting fail with Communication link failure error
- What are acceptable values for the parameter "errorCode" of Dts.Events.FireError in SSIS..?
- unpivot with different destination columns in SSIS Dataflow