Execute SQL Task

• Peter Newman-311337

  Old Hand

  Points: 394

  More actions

  July 23, 2007 at 11:13 am

  #179842

  im stuck trying to get this execute SQL task working,

  SQL Statemant = EXEC ISBUREAUOPEN

  Stored Proc

  IsBureauOpen

  @Open Bit OUTPUT

  how do i set the execute SQL task to get the output from the stored proc into a variable ?

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  July 23, 2007 at 11:50 am

  #721593

  declare @var bit

  exec @var = ISBUREAUOPEN

  select @var

  
  
  A.J.
  DBA with an attitude