Post reply

when transfering, a few rows were missing

  • August 6, 2003 at 12:42 pm

    #358101

    Hi all,

    I trancfered a text file to sql table, a few rows were missing. no error mesage. I did this for more than 2 years. Only this week, I find some rows were missing.

    Any possible reason? Thanks!

    Robert

  • August 7, 2003 at 1:04 pm

    #469073

    How are you transfering the data? bcp, DTS?

    Check that the data in the text file has the same format all along the file.

  • August 7, 2003 at 3:01 pm

    #469094

    Thanks for your response.

    The table only has two columns. I set data type as char. the text file in fact is numbers. I use DTS to transfer.

    The table has about 353000 rows, after transfer only a few rows were missing.

    Thanks!

    Robert

  • August 7, 2003 at 3:26 pm

    #469099

    Thanks for your response.

    The table only has two columns. I set data type as char. the text file in fact is numbers. I use DTS to transfer.

    The table has about 353000 rows, after transfer only a few rows were missing.

    Thanks!

    Robert

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

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