Page 203 - DCAP508_DATABASE_ADMINISTRATION

Unit 14: SQL Server Integration Services

SSIS creates packages which are composed of tasks that can move data from source to Notes
destination, and if necessary transform it.

Within SSIS package the workflow can be defined, the SSIS runtime engine ensures the
tasks inside the package are executed according to the workflow.

14.7 Keywords

Connection Manager: A connection manager is a logical representation of a connection.

Connections: A connection includes the information necessary to connect to a particular data
source.
Containers: Containers group a variety of package components (including other containers),
affect their scope, sequence of execution and mutual interaction.
Event Handlers: A workflow can be designed for a number of events in the different scopes
where they might occur.

Package: A package is a collection of tasks which are executed in an orderly fashion by SSIS
runtime engine.
Precedence Constraints: Tasks are linked by precedence constraints. The precedence constraint
preceding a particular task must be met before that task executes.
Tasks: A task is an atomic work unit that performs some action.
Variables: Tasks may reference variables to store results, make decisions, or affect their
configuration.

14.8 Review Questions

1. Explain the concept of SSIS.
2. Briefly describe the process to import and export data into and from sql server.

3. Discuss the concept of “The SSIS Import/Export Wizard”
4. Describe the various components of SSIS.
5. What is a connection manager? Give few examples of connection managers.

6. Discuss the concept of Containers? What are the four types of containers in SSIS?
7. Write short notes on following:
(a) Precedence constraints
(b) Event handlers
(c) Connection Manager

(d) Variables
8. Discuss the various features of the data flow task.
9. Explain how to create SSIS package.

Answers: Self Assessment

1. XML 2. Action

3. Workflow 4. Connection

LOVELY PROFESSIONAL UNIVERSITY 197