Post reply

SQL 2005 BCP

  • May 3, 2012 at 6:18 am

    #392180

    Need help in exporting single table having 25 million records to multiple flat files of less than 1 million csv files.

    Thanks in Advance

  • May 3, 2012 at 8:19 am

    #1483056

    What sort of help are you requiring?

    Is it splitting the 25m records into 1m exports?

    BCP performance?

    A bit more information would be helpful.

    Thanks

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • May 3, 2012 at 9:34 am

    #1483126

    CoolDude7645 (5/3/2012)

    Need help in exporting single table having 25 million records to multiple flat files of less than 1 million csv files.

    Thanks in Advance

    Try -F (first row) and -L (last row) options

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

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