Forum Discussion
Unreported column about a String or binary data would be truncated error
Based on my understanding, it is not possible to get that data from the failure meassage.
You would have to debug via the below scenarios :
1) you would have to compare the max length of values of each column at source with the schema at the sink
to identify for which column the data is getting truncated
2)try making the length of all columns max and then insert data and then compare the max value length with original column lengths
Based on my understanding, it is not possible to get that data from the failure meassage.
You would have to debug via the below scenarios :
1) you would have to compare the max length of values of each column at source with the schema at the sink
to identify for which column the data is getting truncated
2)try making the length of all columns max and then insert data and then compare the max value length with original column lengths
Hi, thanks for your reply but your suggest is a workaround similar to I do.
Using a data pipeline I can see also the wrong column name in the error message, so I think that unreporting the wrong column is a lack in dataflow gen2.
Thanks