Site feedback

PaulSimon-3102 avatar image
1 Vote"
PaulSimon-3102 suggested PaulSimon-3102 published

Seems to search across all products

I have a specific issue with Azure Data Factory. However, the Q&A seems to be searching across all products even though I launched it from ADF. This makes it useless. There are lots of products that can give a Data would be truncated error.

My specific issue with Azure DF is that I got this error below from the Copy Data tool. Any other ETL tool I have used would have told me exactly which field it had the error with, and which row. However, ADF gives you no clue. This is really poor in what should be a totally new tool that incorporated lessons learned from SSIS.

Operation on target Copy_86q failed: Failure happened on 'Sink' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.InvalidOperationException,Message=The given value of type String from the data source cannot be converted to type nchar of the specified target column.,Source=System.Data,''Type=System.InvalidOperationException,Message=String or binary data would be truncated.,Source=System.Data,'

Paul

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

No Solutions

Your Opinion Counts

Share your feedback, or help out by voting for other people's feedback.