Datasheet

❑ OLE DB Source: Connects to nearly any OLE DB data source, such as SQL Server, Access,
Oracle, or DB2, to name just a few.
❑ Excel Source: Source that specializes in receiving data from Excel spreadsheets. This source also
makes it easy to run SQL queries against your Excel spreadsheet to narrow the scope of the data
that you wish to pass through the flow.
❑ Flat File Source: Connects to a delimited or fixed-width file.
❑ Raw File Source: A specialized file format that was produced by a Raw File Destination (discussed
momentarily). The Raw File Source usually represents data that is in transit and is especially quick
to read.
❑ XML Source: Can retrieve data from an XML document.
❑ Data Reader Source: The DataReader source is an ADO.NET connection much like the one you
see in the .NET Framework when you use the DataReader interface in your application code to
connect to a database.
Destinations
Inside the data flow, destinations accept the data from the data sources and from the transformations.
The flexible architecture can send the data to nearly any OLE DB–compliant data source or to a flat file.
Like sources, destinations are managed through the Connection Manager. The following destinations are
available to you in SSIS:
❑ Data Mining Model Training: This destination trains an Analysis Services mining model by
passing in data from the data flow to the destination.
❑ DataReader Destination: Allows you to expose data to other external processes, such as
Reporting Services or your own .NET application. It uses the ADO.NET DataReader interface to
do this.
❑ Dimension Processing: Loads and processes an Analysis Services dimension. It can perform a
full, update, or incremental refresh of the dimension.
❑ Excel Destination: Outputs data from the data flow to an Excel spreadsheet.
❑ Flat File Destination: Enables you to write data to a comma-delimited or fixed-width file.
❑ OLE DB Destination: Outputs data to an OLE DB data connection like SQL Server, Oracle, or
Access.
❑ Partition Processing: Enables you to perform incremental, full, or update processing of an
Analysis Services partition.
❑ Raw File Destination: This destination outputs data that can later be used in the Raw File
Source. It is a very specialized format that is very quick to output to.
❑ Recordset Destination: Writes the records to an ADO record set.
❑ SQL Server Destination: The destination that you use to write data to SQL Server most efficiently.
❑ SQL Server Mobile Destination: Inserts data into a SQL Server running on a Pocket PC.
12
Chapter 1
04 584359 ch01.qxd 12/16/05 10:20 PM Page 12