Using the SSIS Components
ReadingExcel Services Data with the SSIS Components
The following sections show how to ETL Excel Services data, using the standard SSIS components to query Excel Services tables just as you would SQL Server tables.
Using the Source Component
Using the Source Component details how to add a source component to the package, including defining a connection manager and selecting a data access mode.
Using the Lookup Component
Using the Lookup Component demonstrates how to perform data lookups on a specified set of columns from the source component in a lookup component.
Using the Execute SQL Task
Using the Execute SQL Task details the process for adding an Execute SQL task to your project and executing SQL queries directly.
Defining Custom Views
The component can define virtual tables whose contents are decided by a pre-configured query. See Defining Custom Views for more information.
Calling Stored Procedures
Calling Stored Procedures describes the process for executing stored procedures with a Script component.