Use a format file to map table columns to data-file fields (SQL Server) [!INCLUDE SQL Server Azure SQL Database Synapse Analytics PDW ] A data file can contain fields arranged in a different order ...

First, delete any format-file row that describes a field that is missing from the source data file. Then, reduce the "Host file field order" value of each format-file row that follows a deleted row.