Integration Services

Use the change data capture capabilities of SQL Server 2008 to optimize extract, transform, and load (ETL) operations by refreshing only data that has changed since the previous iteration

Use the improved SQL Server Import and Export Wizard to perform more functional and scalable data transfers

Integrate data easily and affordably: new high speed connectors, offered for free with Enterprise edition, allow you to quickly access data from multiple sources.

Access data in SAP and other common sources, including Oracle, Teradata, text files, OLE DB, and ADO.NET data sources (including ODBC for .NET)

Access data in SAP and other common sources, including text files, Teradata, OLE DB, and ADO.NET data sources (including ODBC for .NET)

Improve integration with other systems because SQL Server 2008 uses ADO.NET for tasks as well as data sources and destinations

Easily integrate service oriented architectures and other nonstandard data sources by using the built-in support for XML and Web Services data

Use the optimized SQL Server destination for data loading, including directly targeted SQL Server Mobile databases

Use metadata integration and shared engineering to load Reporting Services reports or Analysis Services cubes straight from the SSIS pipeline

Take advantage of a scalable transformation engine from lightweight 32-bit systems to high-end 64-bit architectures

Perform powerful operations, such as data and character conversions, creating calculated columns, conditional operations for partitioning and filtering, lookups, sorting, aggregation, and merges

Take advantage of improvements to lookup performance in SQL Server 2008

Automatically improve performance of highly-parallel package designs by using the improved thread pooling of SQL Server 2008

Use Business Intelligence Development Studio to create shared solutions with Analysis Services and Reporting Services, including source control, metadata integration, and the design, testing, deployment, and maintenance of end-to-end business intelligence applications

Use Data Viewers to see the data pipeline at work, visualizing data during transformation in grids, graphs, and charts, while breakpoints, variable watches, and the call stack provide powerful debugging capabilities

Use the code design environment of Microsoft Visual Studio Tools for Applications (VSTA) to write Script tasks in Microsoft C#. NET and Visual Basic. NET, and seamlessly upgrade SQL Server 2005 Visual Studio for Applications (VSA) Script tasks

Code and distribute your own reusable components to meet custom requirements

Build data mining functionality into your SSIS solution not only by training models from integrated data, but also by producing results by applying data mining models to data sources inside your SSIS packages

Use predictive models to impute incomplete and missing data, or use association and clustering models to identify outliers and anomalies for data quality issues—all captured, with rigorous audit and execution metadata

Use the architecture and infrastructure of SQL Server Integration Services to join a remarkably dynamic and diverse community from specialized software vendors to committed users

Easily develop and distribute your own advanced components by using the readily extensible and powerful infrastructure of SQL Server Integration Services

Enjoy active and helpful communities for sharing ideas, components, and support