BCP-Suppressing system output messages after running BCP

[saritha]

Hi,

After running BCP to export data from table to text file, we are getting some system generated messages in the log file as below :

output
------------------------------------------------------------------------------NULL
Starting copy...
NULL
81 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total 30 Avg 0 (2700.00 rows per sec.)

(6 row(s) affected)
==========================
We want to suppress these messages while generating log file. Is there any option for this ?

Saritha.

[Patrick]

.
You have two solutions

1° at xp_cmdshell level you will add ",no_ouput" parameter then the execution will be silently. However, if the exec didn't work correctly (for any reason) nobody will have trace of that.

2° Act at the BCP level with /e and the /o parameters then you will redirect the 'Error' and 'regular result' the pathfiles of your choice.

Thanks & Regards
Patrick

------------
saritha at 4/18/2002 5:52:09 AM

Hi,

After running BCP to export data from table to text file, we are getting some system generated messages in the log file as below :

output
------------------------------------------------------------------------------NULL
Starting copy...
NULL
81 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total 30 Avg 0 (2700.00 rows per sec.)

(6 row(s) affected)
==========================
We want to suppress these messages while generating log file. Is there any option for this ?

Saritha.