How to run a .bat file on the second sql server, from DTS on the first sql server?

• szhou

  Grasshopper

  Points: 23

  More actions

  October 16, 2008 at 11:37 am

  #383103

  This is the second step in the procedure. When first step is done on the first sql server (DTS), I need to run a .bat file on the second sql server as the second step. The .bat need to run locally on the second sql server. Thanks in advance!!

• Garadin

  One Orange Chip

  Points: 29613

  More actions

  October 16, 2008 at 11:57 am

  #886024

  PSExec ? (Part of PSTools) That's kinda a shot in the dark, I haven't tried it, as I don't do much with DTS.

  Seth Phelabaum

  ---

  Consistency is only a virtue if you're not a screwup. 😉

  Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]