Azure Data Factory - Copy activity failed to write to Azure SQL DB

Question

Sreenivas Angara 0

Hello,

I am getting the following error. What is the best way to resolve this issue?

User's image

1 answer

Answer 1

Nandan Hegde 36,716 MVP Volunteer Moderator

You can log the incompatible rows in copy activity and debug which column length needs to be increased

Sreenivas Angara 0 Reputation points

2024-01-05T18:08:38.37+00:00

How?. Some pointers to documentation or outside resources would be appreciated.
Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator

2024-01-08T02:40:47.4866667+00:00

MSFT doc for fault tolerance:

https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-fault-tolerance

Another way to debug (similar thread) :

https://learn.microsoft.com/en-us/answers/questions/84491/data-factory-data-truncation-fails-doesnt-show-the
Oury Ba-MSFT 21,121 Reputation points Microsoft Employee Moderator

2024-01-09T18:32:51.7033333+00:00

Sreenivas Angara

Just checking in to see if the below answer provided above helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Regards,

Oury