Azure Data Factory - pipeline output error RRS feed

  • Question

  • Could you explain, Why I'm getting this error on the pipeline?

    "errorCode": "2200", "message": "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 nvarchar of the specified target column.,Source=System.Data,''Type=System.InvalidOperationException,Message=String or binary data would be truncated.,Source=System.Data,'", "failureType": "UserError", "target": "copy data to stage", "details": []

    Tuesday, September 15, 2020 2:34 PM

All replies

  • Maybe you are trying to write some text to a column that does not have enough size to hold this text.

    Tuesday, September 15, 2020 4:49 PM
  • Hi hmsakibs,
    For questions about Azure, it is recommended to ask the question on the Microsoft Q&A forum and you can get more professional answer.
    Thank you for your understanding.
    Best Regards,
    Daniel Zhang

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, September 16, 2020 2:34 AM