none
SSIS WorkFlow

    Question

  • Hi

    Can any one provide sample for  work flow in SSIS . and how to excute package conditionaly like if package1 is sucess then excute package2 else excute package3 .( more like writeing batch file in Data Stage ETL Tool ).

     

    Thanks & Regards

    Jegan.T

    Wednesday, June 14, 2006 9:07 AM

Answers

  • Have you checked BOL? http://msdn2.microsoft.com/en-us/ms141221.aspx

    Workflow is implemented using precedence constraints. You can define that a task should execute if a preceding task succeeds, fails, or simply completes.

    -Jamie

     

    Wednesday, June 14, 2006 10:03 AM
    Moderator
  • Oh, and if you want to ensure that packages execute in a certain order, call them from a "master" package using some Execute Package Tasks. Control the order of execution by linking these Execute Package Tasks together using precedence constraints.

    -Jamie

     

    Wednesday, June 14, 2006 10:33 AM
    Moderator

All replies

  • Have you checked BOL? http://msdn2.microsoft.com/en-us/ms141221.aspx

    Workflow is implemented using precedence constraints. You can define that a task should execute if a preceding task succeeds, fails, or simply completes.

    -Jamie

     

    Wednesday, June 14, 2006 10:03 AM
    Moderator
  • Hi Jamie,

    Thanks for your suggestion

    Jegan.T

     

    Wednesday, June 14, 2006 10:31 AM
  • Oh, and if you want to ensure that packages execute in a certain order, call them from a "master" package using some Execute Package Tasks. Control the order of execution by linking these Execute Package Tasks together using precedence constraints.

    -Jamie

     

    Wednesday, June 14, 2006 10:33 AM
    Moderator