Share via

Azure data factory

Shreya Singh 0 Reputation points
2023-10-19T12:27:57.3533333+00:00

ErrorCode SqlOperationFailed Type Microsoft.DataTransfer.Common.Shared HybridDeliveryException Message A database operation failed with the following error: Cannot find the object mytracedb 01 parts because it does not exist or you do not have permissions Source","Type-System.Data.SqlClient.SqlException, Message Cannot find the object "mytracedb_01 parts" because it does not exist or you do not have permissions Source Net SqlClient Data Provider,SqlError Number-1088, Class 16,ErrorCode=-2146232060,State=7,Errors-Class-16Number 1088 State-7,Message-Cannot find the object "mytracedb_01_parts

i am able to truncate the table in sql server but when i am writing pre copy script quesry its throwing error

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Erland Sommarskog 107.2K Reputation points
    2023-10-19T21:20:45.9766667+00:00

    I don't much about ADF, but supposedly you are connecting to the wrong server and/or the wrong database.

    0 comments
  4. ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee
    2023-10-20T17:28:09.29+00:00

    Hi Shreya Singh,

    Thank you for posting query in Microsoft Q&A Platform.

    Kindly try below option to resolve above issue.

    1. Check is your SQL linked service test connection is getting successful.
    2. If you SQL is on prem network then use selfhosted IR in linked service.
    3. Make sure you are using the right Database in linked service, in which the dbo.mytracedb_01_parts table is present.
    4. Make sure the user name which you are using in the linked service has the proper permissions to query your table.

    I hope steps will help to resolve the issue. Please let me know if any further queries.

    Please consider hitting Accept Answer button. Accepted answers help community as well.