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]
