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
No comments:
Post a Comment