In addition to an input, the destination may also have an
error output. This is designed for the eventuality that if some data cannot get into
the destination due to some constraints, it can be routed to the error output. The
following schematic shows the data flow destination with multiple inputs and error
outputs. SSIS neither has restrictions on the number of inputs nor on the number of
error outputs.
SSIS Basics
[ 22 ]
The following screenshot shows the various destination options available in the SSIS
designer toolbox. The OLEDB destination in turn supports connection to various
database vendor products, for which OLEDB providers are available.
Of the available Data Flow Destinations, the ones that are described in the book
as follows:
Excel Destination
Flat File Destination
OLE DB Destination
Recordset Destination
SQL Server Destination
Connection Managers
For the source to obtain its input, it has to use a connection manager that configures
the connection to the required data source. Similarly, while loading to a destination,
the connection manager manages the connection to the external source. The
connection managers arrange for valid connection to the data sources. Although the
bulk of activity in SSIS is database related, some of them are not, for example, FTP
task or Send Mail task.
A connection manager represents a logical connection to data. By using the
ConnectionString property, set at design time, it establishes a physical connection
to the data source at execution or run time.
Pages:
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41