What are the containers in SSIS and types

DWQA QuestionsCategory: QuestionsWhat are the containers in SSIS and types
Editor Staff asked 1 month ago

What are the containers in SSIS and types

1 Answers
Editor Staff answered 1 month ago

Containers are like buket or a box which can holds different objects. It is same as SSIS it is a objects which stores tasks. And its primary purpose is to group logical related tasks. And once we place the task in containsers we can do any operation on ths tasks for example we can do looping on container level until we desired. We can alos do nesting. And container is placed inside the control flow. Below are the 4 types of cotainers available in SSIS
Select the best answer from below options
a.Sequence Container:- This type of container can be defined as subset of package control flow.
b.Task Host container:- we can place one task inside the container and this is default container.
c.For each loop container:- In this we loop through container based on enumerator.
d.For loop container:- This types Allow looping based on condition. Runs a control flow till condition is met.