bcp file size.

[zum]

Is there a limit on how big a file can be when bcping out data? I'm trying to bcp out a large file and it keeps failing. I get to 12356000 rows then I get the message:

successfully bulk-copied to host-file.
Error: Writing BCP file (0)!
bcp copy out partially failed

Disk space on my server looks fine. I'm running Sybase 12.0.

Thanks

 

[PDreyer]

bcp 12.0 is old and does not support files greater than 2 GB. Refer to

http://www.sybase.com/detail?id=1011375