Writing Output to SQL Database - ERROR is getting

Question

Hi All,

i am trying to write data from Output tool to SQL Database but i am getting one error

Attached is the image

Please do the needful

Error: Output Data (84): DataWrap2ODBC::SendBatch: [Microsoft][ODBC Driver 11 for SQL Server]String data, right truncation Insert into "PLOT1"("End mat","7Digit","10Digit","Product hierarchy name","IPG","Pack"," PH*PACK-IPG","Inactive_7 digit","Inactive 10-digit","To_Name","To_Yes_No","To_Group","Created on","Stock value avg 12 mth","Division","Business function","Header Material","F4","Packaging information (code)","Industry SubGroup","Material Bulk Indicator","Bulk","Bulk type","Start","Date_New","New SKU","namechangeEnd mat","Months") Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

kosie-snyman · Answer

@Brandie Thank you for the advice, had a similar error and your advice helped me to solve the problem,

BrandonB · Answer

This is most likely due to the size of the data types that are allowed to be written to the table. If your field sizes are too small you will get a truncation error. You should check the table in your database to see what the settings are.