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

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

Thank you.
I will try this Monday.


O.