Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews New MS SQL Server Interviews:MS SQL Data MiningMS SQL Reporting ServicesMS SQL Server 2008MS SQL Server IndexesMS SQL Server JoinsMS SQL Server OptimizationMS SQL Server ReplicationMS SQL Server ViewsMS SQL Server XML IntegrationSQL Database ConceptsSQL Server ArchitectureSQL Server ConstraintsSQL Server CursorsSQL Server Database AdministratorSQL Server FunctionsSQL Server LocksSQL Server Service BrokerSQL Server TriggersSQL Stored ProceduresSSISTransaction Server
Copyright © 2018. All Rights Reserved
SSIS Interview Question:
Explain the use of containers in SSIS and also their types?
Submitted by: AdministratorAd
Containers can be defined as objects that stores one or more tasks. The primary purpose of container is grouping logically related tasks. Once the task is placed into the containers, we can perform various operations such as looping on container level until the desired criterion is met. Nesting of container is allowed. Container is placed inside the control flow. There are 4 types of Container:-
1. Task Host container- Only one task is placed inside the container. This is default container.
2. Sequence Container - This container can be defined as subset of package control flow.
3. For loop container - Allows looping based on condition. Runs a control flow till condition is met.
4. For each loop container - Loop through container based on enumerator.
Submitted by: Administrator
1. Task Host container- Only one task is placed inside the container. This is default container.
2. Sequence Container - This container can be defined as subset of package control flow.
3. For loop container - Allows looping based on condition. Runs a control flow till condition is met.
4. For each loop container - Loop through container based on enumerator.
Submitted by: Administrator
Copyright 2007-2025 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.

https://InterviewQuestionsAnswers.ORG.
