Results 1 to 3 of 3

Thread: bcp issue

  1. #1
    Join Date
    Jan 2003
    Posts
    21

    Unanswered: bcp issue

    I am trying to bcp the syslogins from a 12.0.0.7 ASE server to a 12.5 ASE server.

    I am using the following command:
    bcp master..syslogins in file.txt -c -b1 -Usa -P

    I am getting the error:
    cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.

    Why does this happen and what is the fix?

    Thanks,
    O

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    the table syslogins has changed within 12.5
    you have to use a fmt file

    I have done it the following way

    bcp out with 12.0 fmt file
    bcp in with 12.0 fmt file into a tmp table and then

    insert into syslogins .... as select .... from tmp_syslogins

  3. #3
    Join Date
    Jan 2003
    Posts
    21
    Thank you.
    I will try this Monday.


    O.

Posting Permissions

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