Datatype in Pipneline

Rohit Kulkarni 6 Reputation points

Hello Team,

I have added few columns in the source in copy activity in pipeline and in Mapping section i have mapped it to target Table. while running i am getting error :

Code": 27001,
"Message": "ErrorCode=TypeConversionFailure,Exception occurred when converting value '' for column name 'Fieldname' from type 'String' (precision:, scale:) to type 'Int32' (precision:10, scale:255). Additional info: Input string was not in a correct format.",

Please advise


Azure Data Lake Analytics
{count} votes

2 answers

Sort by: Most helpful
  1. Nasreen Akter 10,706 Reputation points

    Hi @Rohit Kulkarni ,

    From the error message and the images you provided, it looks like your sourceColumn is STRING type and TargetColumn is INT type. Please check DB tables in both sides, source and target and correct the datatype accordingly. Also please check the schema in the dataset (re-import schema if required). Thanks.


    If the above response is helpful, please accept as answer and upvote it. Thanks!

    1 person found this answer helpful.
    0 comments No comments

  2. Rohit Kulkarni 6 Reputation points


    The problem was source datatype (nvarchar(30)) value was more and Target datatype (nvarchar(10))was less.In that scenario also i was facing the issue

    My issue is got resloved now.

    Thanks for providing me suggestion.


    1 person found this answer helpful.