Working with Other SQL Server Features

Microsoft SQL Server 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.

In This Section

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.