Linked service: SQL Server-2019 to Cosmos DB
0
votes
0
answers
194
views
I have created linked service for importing data from Azure cosmos DB to on-prem MS-SQL-2019. Services created from SSMS and test connection is successful, but query is getting error.
Query:
select * from openquery (
linked_service_name,'select * from
cosmos_collection');
>Error: "Error occurred while submitting query text to OLE DB provider "SSISOLEDB" for linked server "linked_service_name"
**Linked service set-up:**
Provider: SQL Server OLE DB
Data Source: User DSN [ Created in ODBC Data source admin ]
Provider String: Secondary key from Cosmos DB
Catalog: Schema name of Cosmos DB
Asked by maverick_1
(1 rep)
Jun 21, 2023, 09:42 AM
Last activity: Jun 22, 2023, 09:48 AM
Last activity: Jun 22, 2023, 09:48 AM