Home Forums SQL Server 2005 Data Corruption order of rows during bulk insert RE: order of rows during bulk insert

  • June 20, 2010 at 3:20 pm

    #1182522

    I strongly recommend you number the rows prior to import.

    I'm sure there are tools available on the web that will add line numbers. I, personally, use a DOS batch file I found on a German web site (comments and description ar all in German, so I don't think it would help that much...)


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]