Welcome to Microsoft Q&A platform and thanks for posting your question here .
As I understand your issue, you are facing this error: "Parquet file contained column 'txn', which is of a non-primitive, unsupported type." while copying data from sql server to adls gen2.
The error message you received indicates that the Parquet file you are trying to use contains a column named 'txn' which is of a non-primitive, unsupported type.
According to the documentation, complex data types such as MAP, LIST, and UNION are not supported in Parquet format. You may need to modify the data in the column 'txn' to a supported type before you can use it. In order to modify the datatype of the file, you can leverage Cast Transformation in Mapping dataflow.
For more details, kindly check this documentation:
Data type mapping for Parquet files
Hope it helps. Kindly accept the answer and mark it as helpful.
@Dilip Kumar Agnihotra ,
Just following up to see if the below answer helped. Please do consider clicking
Accept Answer
as accepted answers help community as well. Also, please click onYes
for the survey 'Was the answer helpful'