reading a Global variable

• sammy16v

  Grasshopper

  Points: 11

  More actions

  April 29, 2003 at 9:29 am

  #159857

  Hi There

  I am currently writing a stored procedure that runs

  ------------------------------------------

  use master

  exec xp_cmdshell "DTSRun /S servername /U username /P password /N package name/A variable"

  ------------------------------------------

  I need the to read this variable so that I can run an oracle stored procedure using its contents.

  any ideas anyone?

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  April 29, 2003 at 10:32 am

  #455714

  It may be long way. However one alternative is as follows.

  Create a batch file (.bat) with following commands

  a) Run the DTSRUN with /A

  b) Print the contents of variable to console.

  In the stored procedure

  a) create a temporary table with one column

  #tmp_consoledata(data varchar(255))

  b) do a INSERT INTO EXECUTE xp_cmdshell batchfile.bat

  Now all the output from the batch file will be available in the temporary table.