Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Azure Data Factory - pipeline output error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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