Export (0) Print
Expand All

Using Integration Services with Other SQL Server Features

New: 14 April 2006

Microsoft SQL Server 2005 provides robust interoperability among SQL Server features. The Integration Services includes a suite of tasks, data flow components, and connection managers that are specifically designed to support the integration of the SQL Server database, data mining, and online analytical processing (OLAP) in Integration Services solutions. For example, in an Integration Services package you can apply in-line business intelligence to the data that the package processes by running a data mining query. Depending on the query results, you can then load and process Analysis Services dimensions, perform other data maintenance tasks, or run SQL statements that create or truncate the tables before the package loads the tables with data.

Topic Description

Using Integration Services with the Database Engine

Describes the Integration Services tasks, dataflow components, and connection managers specifically designed to work with the SQL Server Database Engine.

Using Integration Services with SQL Server Compact Edition

Describes the Integration Services dataflow component and connection manager specifically designed to work with SQL Server 2005 Compact Edition.

Using Integration Services with Analysis Services

Describes the Integration Services tasks, dataflow components, and connection manager specifically designed to work with the OLAP component of Analysis Services.

Using Integration Services with Data Mining

Describes the Integration Services tasks, dataflow components, and connection manager specifically designed to work with the data mining component of Analysis Services.

Using Integration Services with Other Applications

Describes the use of the extensive Integration Services object model to create packages dynamically, or to manage and execute Integration Services packages outside the development environment.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft