I have a sink in a data flow pointed to AzureSQL. There is a set of columns that were at one time booleans, which are now strings. I cannot for the life of me get ADF to change the data type in the output table.

I have a sink in a data flow pointed to AzureSQL. There is a set of columns that were at one time booleans, which are now strings. I cannot for the life of me get ADF to change the data type in the output table.

Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the following two rows: primary key of first row: (202101, 0xdef2170005000000), primary key of second row: (202102, 0xdef2170005000f00).