bcp into syslogins



I'm trying to bcp into a 12.5 Sybase table in tempdb the syslogins file
which was bcp'd out of another server. I keep getting the following
error in regards to the password column -
CSLIB Message: - L0/O0/S0/N36/1/0:
cs_convert: cslib user api layer: common library error: The result is
truncated because the conversion/operation resulted in overflow.

The bcp command I used is: bcp tempdb..tmp_syslogins in syslogins.bcp.c
-b1 -c -t'\t' -eerror2.out -S $DSQUERY -U sa -P $PASSWD

The syslogins was bcp'd out with the -c and has tab-separated columns.
Any suggestions?

Patrick

.



Relevant Pages

  • Re: Whats the bcp (SQL Server) substitute in Oracle??
    ... secured UNIX server using the bcp utility of SQL Server. ... But now this database will be migrated to Oracle 10g. ... Flat File and Out File. ...
    (comp.databases.oracle.misc)
  • Whats the bcp (SQL Server) substitute in Oracle??
    ... secured UNIX server using the bcp utility of SQL Server. ... Flat File and Out File. ...
    (comp.databases.oracle.misc)
  • Re: BCP error 22001 - String data, right truncation
    ... application developers strip those types of garbage characters out before ... > Once I switched to native mode the problem went away. ... >> First be sure the table schema on the target server matches the one on ... >>>I am using bcp to copy a table from one sql server to another. ...
    (microsoft.public.sqlserver.tools)
  • Re: Whats the bcp (SQL Server) substitute in Oracle??
    ... secured UNIX server using the bcp utility of SQL Server. ... But now this database will be migrated to Oracle 10g. ... Flat File and Out File. ...
    (comp.databases.oracle.misc)
  • Re: BCP Utility
    ... Why do you need Linked server for BCP? ... I have to bcp a large tableto linked server, ... > 1) Is there the way to bcp an entire database instead of only a table? ...
    (microsoft.public.sqlserver.programming)