dcsimg
Results 1 to 2 of 2

Thread: BCP log file

Hybrid View

  1. #1
    Ali Alhussein Guest

    BCP log file


    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

  2. #2
    Adam Fortney Guest

    BCP log file (reply)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •