SQL ERROR for importing data

Hello, I got this error while importing data. What does it mean?

ERROR: Import data file: ("Identifier name ';InventoryLegSK;PurchaseDateSK;Passenger_UnitsSold;Priority_Boarding_UnitsSold;Priority_Boarding_Rev' is too long", 1059)
Failed

It means that the string you showed is longer than SQL Server allows for an identifier which is 128 characters. Rename the column/object to something shorter.

1 Like