SSIS Odata connection successful but collection does not load, SSDT 2017
I am trying to connect via an SSIS package within Visual Studio 2017 SQL Server Data Tools 2017 to an OData feed from Microsoft Dynamics 365 (hosted on the Microsoft Azure cloud).
The connection manager tells me when testing the connection "Test connection succeeded". However, when I want to specify this connection in the OData Source Editor it says "Unable to load collection for the connection xxxx, reason: cannot open this connection".
Interestingly, I am able to successfully connect to that OData feed and pull data via Power BI Desktop. This however is not practical as I cannot export data to a SQL Server DB from there.
Turns out, this is a super simple fix. Instead of adding the v9.1 at the end of the path, switch to v8.2 and the collections will pop up.
- 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?