|
|
Posted by panic attack on 08/09/06 06:59
many thanks...
my problem has been solved.
tunc
Erland Sommarskog wrote:
> panic attack (tunc.ovacik@gmail.com) writes:
> > it is a chance for me that such a topic has been opened :))
> > so i can ask something that i need to know...
> >
> > well i am using BCP command to get a text file into SQL Server 2000
> > but i am getting an error message like this one :
> > "string data, right truncation"
> >
> > and i have no idea how i am going to get over this problem!!
> > in what situations does the sql server 2000 return with such an error?
> >
> > what should i do to get over this problem?
>
> First start a new thread, so we can keep different problems apart.
>
> You can try the -e option to get errors to a file, you will then see which
> records in the file that provokes this error. I need however add the caveat
> that not all errors get listed in the error file, and I don't remember if
> this error gets lists.
>
> The two most plausible reasons for the error is
> 1) the file has data that does not fit the table columns.
> 2) there is an error with your delimiters, so that BCP gets out of sync.
>
> If that does not help, post the CREATE TABLE command for the table and the
> exact command line for BCP you are using. If you use a format file, please
> also include a format file. Finally, include a sample of the input file.
> Best is if the sample produces the error message. If the input file
> exceeds 80 characters in length include it as an attachment, so it does
> not get wrecked in news transport.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|