File Connection Manager Connects to files and folders.
Flat file Connection Manager Connects to data in a single flat file.
FTP Connection Manager Connects to a FTP Server.
HTTP Connection Manager Connects to a HTTP or Web Server.
SSIS Basics
[ 24 ]
Manager Description
OLE DB Connection Manager Connects using a OLEDB Provider.
SMTP Connection Manager Connects to an SMTP Server.
ODBC Connection Manager Connects to a data source using ODBC.
SMO Connection manager Connects to SQL Management Server Objects.
Variables
Variables are used to store values that package objects can use at run time. They
assist in communication between objects. Event handlers, containers, tasks, etc.
can all make use of variables. Variables can also be used in the scripting tasks.
Precedence constraints that sequence tasks can also make use of variables in the
definition of constraints. You will see a number of examples of using variables in
the book.
User-defined variables are created by package developer, and system variables
are defined by Integration Services. Both user-defined variables as well as system
variables are case sensitive. While user-defined variables can be defined as and when
needed, system variables are fixed.
A variable is known by its name, description, namespace, read-only or read-write
attribute, whether or not it raises an event, and data type and value. It is created in
the scope of the package or a package object.
Event Handlers
Events of various types occur one after another from the time you start to execute
a package till the time it completes successfully or otherwise.
Pages:
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43