Sample Header Ad - 728x90

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