The following table lists the configured advanced source, lookup, and target properties from Microsoft Azure SQL Data Warehouse V1 mappings that you can retain when you migrate to Microsoft Azure Synapse SQL:

Transformations	Properties retained after migration
Source	Azure Blob Container Name Field Delimiter Number of Concurrent Connections to Blob Store Quote Character
Lookup	Azure Blob Container Name Field Delimiter Number of Concurrent Connections to Blob Store Quote Character
Target	Azure Blob Container Name Field Delimiter Number of Concurrent Connections to Blob Store Truncate Table Quote Character Forward Rejected Rows

The following table lists the configured advanced source, lookup, and target properties from Microsoft Azure SQL Data Warehouse V2 mappings that you can retain when you migrate to Microsoft Azure Synapse SQL:

Transformations	Properties retained after migration
Source	Azure Blob Container Name Field Delimiter Number of Concurrent Connections to Blob Store Pre SQL Post SQL SQL Override On Pre-Post SQL Error Quote Character
Lookup	Azure Blob Container Name Field Delimiter Number of Concurrent Connections to Blob Store Pre SQL Post SQL SQL Override On Pre-Post SQL Error Quote Character
Target	Azure Blob Container Name Field Delimiter Number of Concurrent Connections to Blob Store Truncate Table Pre SQL Post SQL SQL Override On Pre-Post SQL Error Quote Character Forward Rejected Rows