locked
What is the task priority in SSIS 2008 control flow? RRS feed

  • Question

  • Hi Team,

    I am using SSIS 2008.   I am using 4 processor server.

    I am having 12 tasks in my Control flow.  There is no Data Flow task.  All are Execute SQL tasks only.  None of the tasks is having dependency.   Tasks can be executed in any priority.

    When I start executing the package, which task will be performed first?

    Can I give priority like task 6 should be started first since it takes long time?

    Thanks a lot in advance for all the help.

    Lakshmi.

    Thursday, August 9, 2012 8:56 PM

Answers

  • hello Lakshmi

    There is no way to give priorities to tasks other then linking then sequentially.

    If the tasks are not connected by execution flow links, then the task with the lower id (appearing ahead of others in the xml-package file) will start executing 1st.

    But that is typically, not a guarantee.


    Arthur My Blog

    Thursday, August 9, 2012 9:03 PM

All replies

  • hello Lakshmi

    There is no way to give priorities to tasks other then linking then sequentially.

    If the tasks are not connected by execution flow links, then the task with the lower id (appearing ahead of others in the xml-package file) will start executing 1st.

    But that is typically, not a guarantee.


    Arthur My Blog

    Thursday, August 9, 2012 9:03 PM
  • Thanks a lot Arthur.
    Thursday, August 9, 2012 9:08 PM