As a workaround, can you create an empty dataset with no schema. Import the schema in dataflow in the projection tab and then preview.
Azure data factory - column value not flowing through to sink
Clare
1
Reputation point
I have a simple data factory.
Source dataset, alter row (insert or update), sink to destination table. Source and destination are Azure SQLServer
I am having trouble with one column. It is defined as tinyint in both databases.
When I data preview on the source dataset the column has a value
When I data preview on the data flow the column has a null value.
Source and destination mappings are correct.
1 answer
Sort by: Most helpful
-
Kiran-MSFT 691 Reputation points Microsoft Employee
2020-10-24T00:09:23.117+00:00