SQL BCP + dont want message "1000 rows successfully bulk-copied to host-file" while doing bcp.

[s***@gmail.com]

Hi,
I am running bcp command on SQL 2000. it shows message "1000 rows
successfully bulk-copied to host-file" for every 1000 records
processed. is there any method to not to get these messages.
Or atleast we can increase the record limit in message so that it
should be shown like "5000 rows......"

Help in this regard will be really appreciated.

[[e-mail]]

Post by s***@gmail.com
Hi,
I am running bcp command on SQL 2000. it shows message "1000 rows
successfully bulk-copied to host-file" for every 1000 records
processed. is there any method to not to get these messages.
Or atleast we can increase the record limit in message so that it
should be shown like "5000 rows......"
Help in this regard will be really appreciated.

You mention SQL 2000 - if that's Microsoft SQL Server 2000 then you
are asking in the wrong forum, as this forum is for Sybase ASE
(although admittedly 10-15 years ago MS SQL was the same thing as
Sybase SQL Server).

In any case, Sybase's bcp tool does not have an option to make it run
silently (AFAIK). You could redirect the output to a file if you want
to get rid of the messages.

Michael

[Manish Negandhi]

Post by s***@gmail.com
Or atleast we can increase the record limit in message so that it
should be shown like "5000 rows......"

In Sybase, you can use -b parameter of bcp to increase the batch size
of the bcp , -b 5000 will insert batch of 5000 rows instead of 1000 -
which is default value

-HTH
Manish Negandhi
[TeamSybase Intern]