Azure SQL DW - column name is case sensitive with hash distribution
Published Mar 13 2019 06:15 PM 588 Views
First published on MSDN on Sep 13, 2016
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]
Version history
Last update:
‎Mar 13 2019 06:15 PM
Updated by: