Trouble trying to debug Script Task

• Peter Newman-311337

  Old Hand

  Points: 394

  More actions

  November 20, 2007 at 7:28 pm

  #122455

  ***** Spotted the mistake ...... More Sleep Needed 😉

  I have a variable

  Name - "IsRunning"

  Scope - Project Name

  Data Type - Boolean

  Value - False

  In the design Window if i execute a Script Task ( code below ) i get a Task Failed. Can someone point out where im going wrong ??

  Public Sub Main()

  If Dts.Variables("IsRunning").Value = False then

  Dts.TaskResult = Dts.Results.Failure

  exit Sub

  end if

  Dts.TaskResult = Dts.Results.Success

  End Sub

  I would expect the task to complete with a success ??

• Norman Kelm

  SSCommitted

  Points: 1922

  More actions

  November 21, 2007 at 7:57 am

  #753115

  It works if this change is made

  If CType(Dts.Variables("IsRunning").Value, Boolean) = False

  Norman

  DTS Package Search

  http://www.dtspackagesearch.com/

• Powichrowski Marek

  Hall of Fame

  Points: 3423

  More actions

  November 22, 2007 at 2:09 am

  #753328

  Is it this variable added to ReadWriteVariables list (Script option of Script Task)?

• Peter Newman-311337

  Old Hand

  Points: 394

  More actions

  November 22, 2007 at 2:49 am

  #753339

  Thanks Guys, I managed to sort it 🙂