Post reply

bcp a view with a large number of rows

  • September 12, 2003 at 5:47 am

    #84338

    I need to export data using bcp.

    The number of columns outputted will be

    just over 300.

    When I try and run this using bcp I get the message:

    "bcp.exe has generated errors"

    I've tried doing the extract with fewer columns and it works fine so we guess there

    must be a limit to the number of columns bcp can extract. Has anyone else come across this issue? How did you work around it?

    Thanks

    Zoltan

  • September 12, 2003 at 7:16 am

    #473914

    I'm using SQL7 SP4 and can bcp a table with 557 columns with no problems.

    Can only think that it either a problem with data or datatypes.

    Far away is close at hand in the images of elsewhere.
    Anon.

  • September 12, 2003 at 8:20 am

    #473941

    Installed a different Service Pack and bcp works fine now.

    Thanks

    Zoltan

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

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