Home Forums Data Warehousing Integration Services SQL server 2014 and VS 2013 - BuilInsert task - truncate a field data of a CSV file and insert it to SQL table. RE: SQL server 2014 and VS 2013 - BuilInsert task - truncate a field data of a CSV file and insert it to SQL table.

  • Can you please advise how to get rid of this truncation error?

    Why should you have to code around this?

    Speak to whoever created the file and explain that it violates the spec. Then ask them to either

    1) Create a revised file spec, or

    2) Create a version of the file which conforms to the spec.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.