Share via

Short and smallint validation error in azure data factory sink

vinoth rajendran 1 Reputation point
2020-08-10T05:59:35.703+00:00

I have a source table with a column of data type smallint. I try to port this column value to the destination table of same data type. However, when i try to point this source in data flow, smallint column automatically changed to integer. I then converted the column to short using derived column functionality. Still during sink , i got the below error. Could anyone help on this?

{"message":"at Sink 'EmployeeInsert': Column(s) [empId] do not exist or their datatypes do not match the employeeid datatypes. Details:at Sink 'EmployeeInsert': Column(s) [empId] do not exist or their datatypes do not match the employeeid datatypes","failureType":"UserError","target":"EmployeeDataFlow","errorCode"

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,160 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2020-08-10T14:48:33.867+00:00

    Hi @vinoth rajendran ,

    Welcome to Microsoft Q&A Platform.

    Thanks for posting the query. I tried replicating this by taking source and destination table in Azure SQL database and see that dataflow is recognizing smallint datatype as shown in below GIF. Hope this helps! If you are looking for specific source/destination use case please share details and we will be glad to assist in resolving the issue.

    16589-smallinttestingadf.gif