The following
figure shows a list, DataLink.udl Properties, which depends on OLEDB data access
providers. It can be seen that there are a large number of providers, all of which can
be used for connecting to data sources.
??? ??? ???
SSIS Basics
[ 14 ]
The following data access providers have been used in this book:
.NET Provider\SqlClient Data Provider
OLE DB Provider
Microsoft Jet 4.0 OLE DB Provider
Native OLE DB\Sql Native Client
Native OLEDB\Microsoft OLE DB Provider for SQL Server
Native OLEDB\Microsoft OLE DB Provider for Oracle
In SSIS, a source is typically a data flow component that conduits data from external
data sources to other data flow components in a package. The following figure is
a schematic representation of a Source obtaining its input from an external source
and delivering it to the transformation stage. The error output has two columns
describing errors in addition to the columns originating from the source.
Data Transformation
SSIS has built-in transformation that can be used to clean or scrub and standardize
the data required by the target database. Standardizing data in an enterprise,
especially when data is originating from multiple subdivisions having different
standards, is important. Also, with globalization of enterprises, the importance
of transformation has risen. The following figure shows the built-in data
transformations available in Visual Studio 2005 (Standard Edition).
??? ??? ??? ??? ??? ???
Chapter 1
[ 15 ]
Of the available data transformations, the following are used:
Conditional Split
Aggregate
Percentage Sampling
Data Conversion
Character Map
??? ??? ??? ??? ???
SSIS Basics
[ 16 ]
A transformation is an intermediary between a source and a destination.
Pages:
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33