The ConnectionString property would
depend on the type of data source.
??? ??? ??? ??? ???
Chapter 1
[ 23 ]
The following figure shows a schematic diagram of how the connection managers
work with the source and destination adapters in a data flow task. Connection
manager is a device that points to where the data is located (the servers, the files,
etc). Different vendors have different ways of indicating this information. In the
figure shown, the Connection Manager connected to the source is pointing to an
SQL Server 2005 and the destination is pointing to an Oracle 10G XE database
server. The data flow transformations take input from the upstream side (coming
from the Source) to the next data transformation stage if it exists. There may be
many data transformation steps. Finally, the data is passed to the destination adapter
which will write to the Destination after conferring with the connection manager at
its end. It is possible that the servers may change or move, all that will be required in
such instances is to reconfigure the connection.
In order to cater to a variety of data sources, there are different types of connection
managers. The following table shows a partial listing of the connection managers:
Manager Description
ADO Connection Manager Connects to data source using ActiveX data objects
method for data access.
ADO.NET Connection Manager Connects to data source using the .NET provider.
Excel Connection Manager Connects to MS Excel Spread Sheet data.
Pages:
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42