checking return code from BCP

• sweeper_bill

  Ten Centuries

  Points: 1015

  More actions

  February 5, 2002 at 9:38 am

  #77778

  I have a bat file that does multiple BCP commands. I want to check the result of the first BCP command before executing the second. The DBA tells me ERRORLEVEL does not work with BCP. Is there a way I can check to see if the bcp command executed properly while running the commnad in a .BAT file?

  William H. Hoover

  Louisville, Ky

  sweeper_bill@yahoo.com

  
  William H. Hoover
  Louisville, Ky
  sweeper_bill@yahoo.com

• Deuce

  SSCrazy

  Points: 2712

  More actions

  February 6, 2002 at 2:36 pm

  #423358

  Bill,

  Run each BCP command separately in a DTS package. Add a workflow between each of them. On Success, go to the next.

  Good luck

  John