PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: rj <rj at chele dot cais dot net>
Subject: Re: BCP questions
Date: May 26 1999 5:41PM

This error usually means that there is data in that field that cannot
be converted to integer. I would suggest checking the data you are
attempting to bcp into the server.

On Wed, 26 May 1999, Steven Cruz wrote:

> Michael Peppler wrote:
> > 
> > Steven Cruz writes:
> >  > Hello;
> >  >
> >  >      I have few little questions, where can I find documentation on
> >  > Sybase::BCP? I am currently using the Sybase::DBlib and I am
> >  > encountering an error on loading some data. The problem I have is that I
> >  > try to track down where these error messages are being generated from
> >  > (to get more information about the error). I have done nothing at all to
> >  > handle any errors, but yet they keep printing.
> > 
> > Unfortunately I haven't worked on Sybase::BCP in a long time...
> > 
> > An example of the errors, and if possible the data that is causing
> > them, would be helpful.
> 
> 	Here you go.  
> 
> The error
> DB-Library error:
>         Attempt to convert data stopped by syntax error in source field.
> 
> 
> I have traced down the error to an Integer (DB definition) field. It is
> the 5th field. It works for all rows without this field.  Oddly enough I
> have used this script to load other tables with an int field and have
> never had this problem. 
> 
> Any suggestions?
> 
> Thank you 
> 
> Steven CRuz
> 
> 
> > Michael
> > --
> > Michael Peppler         -||-  Data Migrations Inc.
> > mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
> > Int. Sybase User Group  -||-  http://www.isug.com
> > Sybase on Linux mailing list: ase-linux-list@isug.com
> 
>