DataWrap2ODBC::SendBatch: [Microsoft][SQL Server Native Client 11.0]String data, right tru

[nhunter]

Designer 11.5.1.35081

I'm getting this message when using an output control to write data to a SQL server database table

DataWrap2ODBC::SendBatch: [Microsoft][SQL Server Native Client 11.0]String data, right truncation 

I added formulas to check the length of each of the text values and they are all shorter than the size of the corresponding columns in the table.

I tried writing the data to an Excel worksheet, then loading the data from the worksheet to the SQL server table and this workedfine.

I tried trimming all the text values but this did not help.

I'm looking for more ideas to help diagnose and fix the problem.

Is this issue only caused by text fields which are too long? There are also Date and Fixed Decimal values in the data. Could one of them be causing the problem? 

[bmalak_98]

I'm getting this error, too. 

• An old Stack Overflow post from 2008 said this is related to putting some records that are too long into a table that has smaller limits. https://stackoverflow.com/questions/183488/what-does-the-sql-server-error-string-data-right-truncati...
• So, if you are trying to force a length 15 string into a varchar 3, or a 19.6 decimal into a 19.5 decimal, this could cause the error.  
• another post in the same thread said it may be incompatible or faulty MS ODBC drivers

These may be some ideas to try and play with to fix.

[bmalak_98]

On further testing,

• I found a field that I was trying to load into an existing MS SQL table had some values with character length 4
• The MS SQL table for this field was set to nvarchar(3)
• I changed the table design to nvarchr(10)
• I re-ran the flow, NO ERRORS!!!