Explore topic-wise InterviewSolutions in .

Who should TAKE advantages of SSIS?
Below are the professionals or user who can make BENEFITS of SSIS. Or the below are the job role will get benefits from learning SSIS.
(1)Business Intelligence Professionals
(2)DATA Warehousing Professionals
(3)DATABASE Administrators
(4)Software Engineers
(5)ETL Developers
(6)Aspirants who is trying there luck in Database Designing.

What are the containers in SSIS and types
As we know containers is like a buket or a box which can holds different objects. Similarly in 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
1.Task Host container:- we can place one task inside the container and this is default container.
2.Sequence Container:- This type of container can be defined as SUBSET of package control flow.
3.For loop container:- This types Allow looping based on condition. Runs a control flow till condition is met.
4.For each loop container:- In this we loop through container based on enumerator.

Why Variables are most POWERFUL in SSIS
Because plays an important roles in SSIS. Variables help us to dynamically control the package at run-time. Below are the latest task that we can do with the help of variables.
1. updating the properties at run-time
2. populating the query parameter VALUE at run-time
3. USED in script task
4. Error HANDLING logic and
5. With VARIOUS looping logic.