In fact, a package can be empty;
however, being empty, it will achieve nothing. In order to have functionality, it
should have a control flow element, and one or more data flow elements.
A package can be either assembled using the graphical design tools that SSIS
provides, or can be built by writing a program. The package built using these
methods can be saved to Sql server, an SSIS Package store, or to a file system. The
saved package can be retrieved, executed, modified, and saved.
The Control Flow Elements
As mentioned previously, the control flow elements consist of containers and tasks.
The following figure shows the various items that you can find in the Toolbox that
belongs to Control Flow Items. Tasks do all the work, and the containers provide the
tasks with a medium to orchestrate them. Containers may contain other containers as
well. The precedence constraints further orders the flow.
The list of tasks in SSIS includes most of the tasks that one would find in its earlier
embodiment, the DTS designer. The various tasks can be more generically classified
under??”data preparation tasks, analytical services related tasks, scripting tasks, SQL
Server tasks, maintenance tasks, etc. You will have the opportunity to work with
some of these tasks in the various chapters of this book.
??? ??? ??? ??? ??? ???
Chapter 1
[ 11 ]
Of the available control flow tasks, the following are used in this book :
Send Mail Task
Data Flow Task
Bulk Insert Task
XML Task
Web Service Task
Transfer Database Task
Execute Process Task
File System Task
Execute Package Task
??? ??? ??? ??? ??? ??? ??? ??? ???
SSIS Basics
[ 12 ]
Execute SQL Task
FTP Task
ActiveX Script Task
Script Task
Maintenance Plan Task
Data Flow Components
SSIS provides three types of data flow components??” sources, destinations and
transformations.
Pages:
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31