BCP log file

[Ali Alhussein]

hi, I am running bcp to back up a table, I want to view a log after the bcp process end. HOw can I create a log file to see the number of rows being copied
ali

[Adam Fortney]

Ali,

You would add -o then a path/file name following in order to log the results to a file. Here is an example:
bcp "SQL Code here.." queryout export.txt -c -S ServerName -U UserId -P password -o c:cpsqlloglog.txt

-Adam Fortney


------------
Ali Alhussein at 1/4/00 1:22:41 PM


hi, I am running bcp to back up a table, I want to view a log after the bcp process end. HOw can I create a log file to see the number of rows being copied
ali