What are all the Container Tasks in SSIS ?
SSIS Provides 4 types of Container Tasks. They are
Task Host Container:
Every task is associated with a self container which provides isolated environment for task execution. Task host
container not visible. We can not drag from tool box.
Forloop Container :
This is used to execute one or more tasks repeatedly fixed no of times.
Foreachloop Container:
This is used to execute one or more tasks frequently unknown number of times based on the collection of items.
This will work based on enumerable
Sequence Container:
It will not change the execution order of task. This is used to
SSIS Provides 4 types of Container Tasks. They are
- Task Host Container
- For loop Container
- Foreach loop Container
- Sequence Containe
Task Host Container:
Every task is associated with a self container which provides isolated environment for task execution. Task host
container not visible. We can not drag from tool box.
Forloop Container :
This is used to execute one or more tasks repeatedly fixed no of times.
Foreachloop Container:
This is used to execute one or more tasks frequently unknown number of times based on the collection of items.
This will work based on enumerable
Sequence Container:
It will not change the execution order of task. This is used to
- Implement container scope of variables.
- Enable/disable tasks as a group
- Transaction implementation
No comments :
Post a Comment