Post reply

How Do You Determine Which Records Fail to Load Using BCP

  • October 5, 2010 at 12:12 pm

    #227306

    Hi Folks

    I am using BCP for the first time trying to import 18,265 records into a table

    All but 4 records loaded

    received error:

    SQLState = 22005, NativeError = 0

    Error = [Microsoft][SQL Server Native Client 10.0]Invalid character value for cast specification

    How can I determine which 4 records out of the text file did not load

    Is there any debugging option available ?

    Thanks

    Jim

  • October 5, 2010 at 12:21 pm

    #1231971

    You can output failed rows to a file using -e c:\errorfile (or whatever path you'd like).

  • October 5, 2010 at 12:37 pm

    #1231988

    Thanks Derrick

    I will give it a shot

    Jim

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

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