BCP: how to determine success or failure

• drewj840

  SSC Veteran

  Points: 222

  More actions

  August 19, 2003 at 8:57 am

  #80854

  I have a script that BCP's a database's DTS packages to a flat file (in sql native format) and then imports the DTS packages to another server. How can I tell in the larger script file within which this runs if the BCP was successful or not? This will determine whether I go on further or rollback.

• mccork

  SSC-Insane

  Points: 22288

  More actions

  August 19, 2003 at 3:17 pm

  #470484

  Is the controlling script a T-SQL script (running xp_cmdshell), a windows batch script, or something else?

  You can check for the "n rows copied." output from bcp.

  Cheers,

  - Mark

  
  Cheers,
  - Mark