Branching in DTS package

• Mike Austin-398977

  Say Hey Kid

  Points: 697

  More actions

  January 30, 2007 at 5:32 pm

  #68263

  I'm writing a high-level DTS package that calls several sub-packages in a specific sequence.  I don't want to continue with the process if a sub-package fails.  What I was hoping to do was retrieve some data from a log table using an "Execute SQL Task" and store the results in a global variable.  I then use an ActiveX script to retrieve the global variable.  Here's the code:

  Function Main()

  Dim intContinueStatus

  intContinueProcess = DTSGlobalVariables("ContinueProcess")

  If intContinueProcess = 0 then

   Main = DTSTaskExecResult_Success

  else

   Main = DTSTaskExecResult_Failure

  end if

  End Function

  ContinueProcess is of type integer.

  I was hoping that I could then use the "Success" and "Failure" workflows to direct processing.  Unfortunately, it doesn't appear to work that way.  If I set the result of the function to failure, shouldn't it direct the processing to the "Failure" workflow destination step?  If not, what is the best way to perform branching in a DTS package?

  TIA,

  Mike

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 30, 2007 at 7:01 pm

  #686666

  Check sqldts.com for this kind of solutions...

  check the following link which may help you...

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

   

  MohammedU
  Microsoft SQL Server MVP