Post reply

SSIS Sequence Containers

  • March 16, 2012 at 11:03 am

    #147028

    Hi,

    I have two sequence containers.

    Sequence Container 1: imports data using a Data Flow Task performs transnformations and loads data into a table (TABLE A). This table has khistircal information and is to be constantly updated via this package

    Sequence COntainer 2: imports data using a Data Flow Task performs transformations and loads another data table.

    BUT it also needs to run queries on the table created in the first Sequence COntainer. These quesries will then update this second table.

    Could you please advise if it is possible to run query across all the historical data in TABLE A as well as any new data added as part of the process in Sequence Container 1:.

    Any advise would be much appreciated.

    Thanks,

  • March 16, 2012 at 1:42 pm

    #1460741

    Do these containers run at the same time? If so you are likely to end up with blocking. If not then you can probably reference the table from A, depending on where and what kind of table it is.

    Sequence containers provide only a little separation, their purpose is to encapsulate a set of processes and it can have its own variables in scope. Can you tell use a bit more about the source and destinations of the data-flows in each container.

    Thanks.

    CEWII

  • March 16, 2012 at 2:26 pm

    #1460770

    Thank you for your reply.both the source and the destination are sequel server database tables.

    The sequence containers are at present set to run in parallel, I am not sure how to prioritise these containers.

    Once the containers are prioritised and the package is run and all the tasks in the sequence container 1 has been completed, at that point would the data have been written to TABLE A?

    I appreciate your help.

    Thank you

  • March 16, 2012 at 3:57 pm

    #1460803

    Yes it would have all been written to table A, to control precedence click on the first container, you are gonna see a little green arrow pop out at the bottom, drag that to the second container.. Boom container 1 is first..

    CEWII

  • March 16, 2012 at 8:28 pm

    #1460821

    Thank you very much 🙂

    Thanks to your explanation I know how it works internally now .. I was under the assumption until the whole package runs may be the data is not physically copied to the table!

    Many thanks ..

  • March 16, 2012 at 9:41 pm

    #1460824

    You are very welcome.

    CEWII

Viewing 6 posts - 1 through 5 (of 5 total)

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