Pipe osql output to a variable

• Babij

  Grasshopper

  Points: 22

  More actions

  September 21, 2004 at 9:38 am

  #85384

  HI,

  has anybody an idea how I can pipe the output of an osql-select command within a cmd.file to a variable to react on this variable from within the same cmd-file. I have to start an system-action within a dts-step depending on the result of that select command.

  Many thanks in advance

• Luc Bolly-157258

  Newbie

  Points: 6

  More actions

  September 22, 2004 at 3:10 am

  #523928

  Quite easy. You redirect osql to a file, then you read and parse the content of the file with a FOR /F

  example (to be encoded in mytest.cmd and to be customized for your environment):

  set TEMPFILE=%TEMP%\myprocess%RANDOM%.tmp

  osql -S myserver -E -d mydb -Q "SELECT userid, fullname FROM users" > %TEMPFILE%

  FOR /F "skip=2 tokens=1,*" %%a IN (%TEMPFILE%) DO (

    IF "%%a"=="XYZ" set Fullname=%%b

  )

  IF EXIST %TEMPFILE% del %TEMPFILE%

  Regards

  Luc Bolly

  ---

  Kindest Regards,

  Luc Bolly