When you try to import dimensionMember table (where data resided in MS-Access, MS-Excel or MS SQL Server) into a SAS ABM model, you might get the following error:

1. [Microsoft][ODBC SQL Server Driver][SQL Server] Bulk insert data
conversion error (truncation) for row 1, column 4 (Name).
[Microsoft][ODBC SQL Server Driver][SQL Server] Bulk Insert:
DataFileType was incorrectly specified as char.  DataFileType will be
assumed to be widechar because the data file has a Unicode signature.
(at sas.abcm.Components.Interop.BulkInsertExecutant.Execute(String
strServerName, String strDbName, String strUser, String strPassword,
String StrTableName, String strDataFilePath, Int32 nBatchSize) at
sas.abcm.Components.Interop.BulkInsertExecutant.ExecuteWithConnectionStr
ing(String strConnection, String strTableName, String strDataFilePath,
Int32 nBatchSize) at sas.abcm.import.BulkInsert.Execute() at
sas.abcm.import.Model.ExecuteBulk() at
sas.abcm.import.TreeTable.OnPostRowset (ETable eTable, String
sTableName) at sas.abcm.import.RowsetLoader.LoadTable(ModelTable MdlTbl)
on row x of table DimensionMember/DimensionMember

Where row x is the row number indicates the problem was found.

This may happen if the Dimension Member Names you're trying to import into SAS ABM model contains more than 64 characters.

To resolve this, please truncate your dimension Member Names to 64 characters or less.