1177
Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services
52
■ (^) General: For name, description, and annotation options. Although the default
annotations are usually adequate, consider enabling additional annotations for
more complex fl ows with intertwined paths.
■ Metadata: Displays metadata for each column in the Data Flow path, including data
type and source component. This information is read-only, so adjust upstream com-
ponents as necessary to make changes, or use a Data Conversion transformation to
perform necessary conversions.
■ Data Viewers: Enables different types of Data Viewers to be attached to the path
for testing and debugging.
Understanding SSIS Sources
Data Flow sources supply the rows of data that fl ow through the Data Flow task. Each
source has two different editing options: Edit (basic) and Show Advanced Editor; although
in some cases the basic Edit option displays the Advanced Editor anyway. The common
steps to confi guring a source are represented by the pages of the basic editor:
■ Connection Manager: Specify the particular table, fi les, view, or query that pro-
vides the data for this source.
■ Columns: Choose which columns appear in the data fl ow. Optionally, change the
default names of the columns in the data fl ow.
■ Error Output: Specify what to do for each column should an error occur.
The advanced editor provides the same capabilities as the basic editor in a different format,
plus much fi ner control over input and output columns, including names and data types.
Table 52-2 outlines available Data Flow Sources.
TABLE 52-2 Data Flow Sources
Source Defi nition
ADO Net Uses an ADO.NET connection manager to read database data, either by identify-
ing a database object or entering a query to execute.
CDC
Source
Uses an ADO.NET connection manager to read database data from a SQL Server
CDC enabled table.
Excel Uses an Excel connection manager and either a worksheet or named ranges as
tables. Data types are assigned to each column by sampling the fi rst few rows
but can be adjusted using the advanced editor.
Flat File Requires a Flat File connection manager. Delimited fi les translate zero-length
strings into null values for the data fl ow when the RetainNulls property is true.
Ole DB Requires an OLE DB connection manager.
Raw File Often used when data processed by one stage of a package needs to be stored
and reused by a later stage.
Continues
c52.indd 1177c52.indd 1177 7/31/2012 10:29:29 AM7/31/2012 10:29:29 AM
http://www.it-ebooks.info