Datatype in Pipneline

Rohit Kulkarni 6

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

Thanks
RK

Rohit Kulkarni 6 Reputation points

2021-02-12T19:51:18.56+00:00

Please refer the screenshot below
Rohit Kulkarni 6 Reputation points

2021-02-12T19:51:44.883+00:00

both the source and target are in Azure sql server
Rohit Kulkarni 6 Reputation points

2021-02-13T04:34:00.393+00:00

Hi Nasreen,

I need to use explicit conversion. Which all predefined function i need to use.

Thanks
RK
Rohit Kulkarni 6 Reputation points

2021-02-13T18:35:37.983+00:00

Hi Nasreen,

After Matching the datatype from source to Target.I am getting error :

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,'
Nasreen Akter 10,751 Reputation points

2021-02-13T19:08:12.407+00:00

Hi @Rohit Kulkarni ,

It could be because of the length of your DB column e.g., if your column is defined as nvarchar(100) and you are trying to insert string with 200 chr. Would you please check the column length in the DB Table. Thanks!
Rohit Kulkarni 6 Reputation points

2021-02-13T19:43:59.367+00:00

I have mapped the datatype value is same now.Still i am getting the same error.

Please advise.
Nasreen Akter 10,751 Reputation points

2021-02-13T19:59:40.827+00:00

Hi @Rohit Kulkarni , that is strange! :( Would you please match datatype for every columns in the source and target Tables and see if there is any mismatch. If the issue still persists, please provide some screenshots with the schema for both table. Thanks!

2 answers

Nasreen Akter 10,751 Reputation points

2021-02-12T20:53:24.487+00:00

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!
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment
Rohit Kulkarni 6 Reputation points

2021-02-13T20:22:28.587+00:00

Thanks.

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.

Regards
RK
Please sign in to rate this answer.

1 person found this answer helpful.
Nasreen Akter 10,751 Reputation points

2021-02-13T20:25:54.91+00:00

@Rohit Kulkarni , glad to know that your issue has been resolved. :)

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-02-17T02:45:17.997+00:00

Thanks @Rohit Kulkarni for sharing your findings and glad to know that your issue was resolved. Please feel free to upvote and accept the answer that was helpful as it would help other community members to find the answer quickly.

Appreciate much for helping the community and sharing your knowledge @Nasreen Akter :). Keep rocking!!
Sign in to comment