MS SQL Server fixing String data, right truncation error (version 3.2.87y)
By Michael Bock - December 27, 2013
When writing to Numeric or Decimal fields in SQL Server, we now cut of decimals after number of allowed decimals defined in the layout for the table.
This should avoid the "String data, right truncation" error on Decimal fields.
About the author
Michael founded Rapidi on technological excellence, fantastic customer service and continuous improvement. A data integration specialist since 1987, he remains focused on creating technology that solves real business problems.