CODEWITHSUNDEEP
azureazure-sql-databaseazure-data-factory
shoyab
shoyab

Reputation: 13

Is there any solution for this azure datafactory error?

I am facing below datafactory error while lodaing data from sql server to blob by using data factory.Can anyone give some inputs on this issue?

{ "errorCode": "2100", "message": "Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Reference to database and/or server name in 'demo.INFORMATION_SCHEMA.TABLES' is not supported in this version of SQL Server.',Source=,''Type=System.Data.SqlClient.SqlException,Message=Reference to database and/or server name in 'demo.INFORMATION_SCHEMA.TABLES' is not supported in this version of SQL Server.,Source=.Net SqlClient Data Provider,SqlErrorNumber=40515,Class=15,ErrorCode=-2146232060,State=1,Errors=[{Class=15,Number=40515,State=1,Message=Reference to database and/or server name in 'demo.INFORMATION_SCHEMA.TABLES' is not supported in this version of SQL Server.,},],'", "failureType": "UserError", "target": "ListTablesIn sql", "details": [] }

Upvotes: 0

Views: 2292

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

Please use Query operation to get the data from INFORMATION_SCHEMA.TABLES: enter image description here

Or set the schema with INFORMATION_SCHEMA and table name: TABLES in Source dataset: enter image description here

I tested and it all works well in my Azure SQL database.

Update:

Congratulations that you resolved the issue by choose database in linked service.

Upvotes: 0

Related Questions