What is Sequence Container?

Sequence Containers handle the flow of a subset of a package and can help you divide a

Package into smaller, more manageable pieces. Some nice applications that you can use

Sequence containers for include the following:

·         Grouping tasks so that you can disable a part of the package that ’ s no longer needed
·         Narrowing the scope of the variable to a container
·         Managing the properties of multiple tasks in one step by setting the properties of the      Container
·         Using one method to ensure that multiple tasks have to execute successfully before the next task executes
·         Creating a transaction across a series of data - related tasks, but not on the entire package
·         Creating event handlers on a single container, wherein you could send an email if anything inside one container fails and perhaps page if anything else fails

SSIS Interview Questions