<dfateman@gmail.com> wrote in message
news:1177985779.600018.233720@q75g2000hsh.googlegroups.com...
> Hi all,
> I'm migrating a process from SQL 2000 to 2005. it generates an XML
> file using the cmd: bcp "EXEC PROD.dbo.client_export_events_xml 1"
> queryout "e:\cli_DP\cli_events.xml" -S"PRD-SQL1\SQL2005" -Uxxx -Pxxxx -
> c -r -t
>
> The proc works fine in SQL 2005 SSMS, BCP crashes with the following
> error. No data is pushed to an output.
> -THanks! D
> Starting copy...
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Server
> data (304
> 6 bytes) exceeds host-file field length (0 bytes) for field (1). Use
> prefix len
> gth, termination string, or a larger host-file field size. Truncation
> cannot oc
> cur for BCP output files.
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Server
> data (390
> bytes) exceeds host-file field length (0 bytes) for field (1). Use
> prefix leng
> th, termination string, or a larger host-file field size. Truncation
> cannot occ
> ur for BCP output files.
>
> 2 rows copied.
> Network packet size (bytes): 4096
> Clock Time (ms.): total 438
>