Post reply

BCP - String data, right truncation!

  • January 7, 2009 at 1:15 pm

    #922865

    That "feature" can only be controlled with SET ANSI_WARNINGS OFF which is a connection property. You could try BULK INSERT instead and run it with that SET option "off". I don't think bcp allows you to specify set options except for QUOTED_IDENTIFIERS.


    * Noel

  • January 7, 2009 at 1:18 pm

    #922868

    Thanks for the assistance.

    I have actually gone back to my data files and truncated the data to fit in the target columns.

    Luckily the field in question is consistent across all my data files and thus it was not that much of an effort.

    Whatty

  • January 7, 2009 at 1:19 pm

    #922869

    That's much better (consistent) and does not requires of any tricks!


    * Noel

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply