Results 1 to 3 of 3

Thread: BCP problem

  1. #1
    Join Date
    Feb 2005
    Posts
    3

    Unanswered: BCP problem

    Hi,

    I have downloaded data from a sybase table uing BCP without any row terminator and column terminater specified. Before "BCP in" I have used ";" for column terminator and "/n" and row terminator. If I will load data one row by row it is working fine. But if I will load more than one row, 1st row goes fine.. second row 1st column gets truncated. Please help..

    Thanks,

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    it would be easier if you should us the syntax of the commands...and this is a sql server forum btw
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    give native mode a try (-n). I believe that is the default of Sybase if you do not specify row and field terminators.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •