Creating an Out File with BCP

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  May 17, 2005 at 12:55 pm

  #362593

  Hello,

  I am looking for an example of how to use the 'o' switch with BCP so that I can create an out file after BCP populates several tables.

  I have a batch file in which BCP populates thirty tables. I'd like to create an out file after the thirty tables are populated so that a vb6 application can know when the batch file is done.

  Any ideas?

  Thank you for your help!

  CSDunn

• Jersey Moe

  SSChasing Mays

  Points: 652

  More actions

  May 18, 2005 at 9:48 am

  #559634

  Although I have never used the -o switch, I do run a similar batch update.

  Within the batch file I log the results to *.log to provide an audit trail.

  bcp.exe "Select * from databasename..tablename" queryout c:\txt\output.txt -Sservername -Uusername -Ppassword -f c:\fmt\output.fmt -c >>c:\LOG\output_bcp.log

  I can query the log for the BCP results.

   

  JerseyMo

   

   

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  May 19, 2005 at 7:23 am

  #559840

  Thanks for the suggestion. I wound up abandoning my out file approach after I was able to implement a pretty good solution in the vb6 app using 'Shell and Wait'.

  CSDunn