The source, destination, and the transformation stages are connected
by a sequencing path to maintain the order of flow.
Connection Managers: They stand apart, and facilitate connection to various
sources for both extracting (sources) and loading (destination).
Variables: They are used to communicate between various objects.
The objects are isolated from one another by design to bestow security,
manageability, and maintainability. The variables that support dynamic
updating of column values, conditions used in establishing precedence of
flow, and reference to record-set destination are some of the examples.
Event Handlers: They run in response to events raised by other objects at run
time. Every container has an event handler associated with it that executes at
run time.
Log Providers: These are objects, used for logging package run time
information.
In addition to this, there are features that help in debugging and diagnosing
problems in design. In the following sections, you will learn some of the basic details
about each of the above topics. You will also be using them in the various exercises
that you will be doing.
??? ???
???
??? ???
???
???
SSIS Basics
[ 10 ]
The SSIS Package
The package is an assembly consisting of the several objects described briefly in the
previous section. It may also include other packages (nested package). Specifically it
can consist of:
Connections
Control Flow Elements
Data Flow Elements
Event Handlers
Variables
Configurations
All elements are not necessary to build a package.
Pages:
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30