When using PolyBase bulk operation to load data into Azure SQL DW (Data Warehouse) and using the HASH distribution
you may receive this error message:
[OLE DB Destination ]: The source and target columns must be in the same order in the INSERT BULK statement
An OLE DB record is available. Source: “Microsoft SQL Server Native Client 11.0” Hresult: 0x80004005 Description: “The source and target columns must be in the same order in the INSERT BULK statement.”.
make sure you use the same case for column names for the HASH function because this implementation is case sensitive
e.g [ColumnName] cannot be [columnname]