November 20, 2003 at 4:24 am
Hi,
I am trying to BCP stuff out from the database into files. I am running the stored procedure and I do get stuff out, but I am encountering this error. Any ideas?
Warning: Server data (3046 bytes) exceeds host-file field length (0 bytes) for field (1). Use prefix length, termination string, or a larger host-file field size. Truncation cannot occur for BCP out
put files.
When I run it through DTS it supresses the error. That's ok, but I would rather run it through osql and a batch file.
November 20, 2003 at 9:35 am
Does the data file get created and populated?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 27, 2003 at 6:34 am
quote:
Sorry, been away for a while. Yes the confusing thing is that the file is created and the data is populated successfully.G./
Does the data file get created and populated?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply