Post reply

SSIS Precedence

  • August 19, 2010 at 2:47 pm

    #1209374

    Woot - thanks for the QOD.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 23, 2010 at 12:59 am

    #1210262

    Michael Riemer (8/19/2010)

    Interesting question!

    I don't quite see how the first answer doesn't also qualify if the group is within the sequence container? Depending on the nesting you have in the package both the first or third could be right or wrong.

    I am sorry if the question I am about to ask is too naive: A sequence container in my understanding is used to bunch a group of tasks (again "tasks" could be for example script tasks, executables or nested containers).

    Now if the "group" is within the sequence container - does it mean there is only one sequence container in the package? I am taking "package" and "group" as synoymous. Pls let me know.

    To me it makes complete sense that within a package - there could be individual "tasks" and then sequence containers having "tasks" and while it does not look possible (in my opinion) to link the TASKS WITHIN THE SEQUENCE CONTAINERS with tasks OUTSIDE the sequence containers - it looks completely logical to link the Sequence container itself with other tasks within the package.

    Saurabh Dwivedy
    ___________________________________________________________

    My Blog: http://tinyurl.com/dwivedys

    For better, quicker answers, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537

    Be Happy!

  • August 23, 2010 at 1:59 pm

    #1210678

    Some excellent points raised here.

    I could have been clearer if I'd added language to indicate more about the arrangement of the tasks, groups, and sequence containers. Perhaps adding language to indicate I was thinking about a package containing only a sequence container and three grouped tasks, with the group containing only tasks and a sequence container continaing only tasks.

    If only you could have seen the diagram in my head when I formulated the question.

    I did not think about the question in that light and apologize for not being more clear.

    Andy

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • August 29, 2010 at 7:18 am

    #1213528

    My eyes stumbled over this several times... "inside groups"... maybe if the questions had been ordered a bit differently it would be easier to figure out which answer is correct.

    Jamie

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply