Azure SQL DW - column name is case sensitive with hash distribution

  • Article

Symptoms:  

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 [471]]: 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.".

 

Resolution:

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]