Global output parameter not being set

• Mike Austin-398977

  Say Hey Kid

  Points: 697

  More actions

  March 6, 2007 at 11:04 am

  #69871

  Hi,

  I have an Execute SQL Task that has the following code:

  TRUNCATE TABLE dbo.DTS_Run_Status_Log

  exec dbo.DetermineRunStatus4 'UnZip Files', 'CMP_Daily_Master', 'Main','Import Text Files'

  The stored proc returns a single value, either 0 or 1, called RunStatus.  I have defined an Output Parameter of type Row Value called RunStatus that matches to a global variable of the same name.  The Global Variable is initialized to 99.  So, output parameter RunStatus is mapped to Output Global Variable RunStatus.  The problem is that the Global Variable is not being set to the result of the stored procedure.  The value never changes from 99.  

  BTW, removing the Truncate statement has no effect and running the exec statement from Query Analyzer returns the proper result.

  As usual, the BOL and my books have absolutely nothing on this.

  TIA,

  Mike

• Russel Loski

  SSCertifiable

  Points: 7059

  More actions

  March 6, 2007 at 12:06 pm

  #693392

  Check this out:

  http://www.sqldts.com/234.aspx

  Russel Loski, MCSE Business Intelligence, Data Platform