Data Warehousing

Build enterprise-class data integration solutions with SQL Server 2008 R2 Integration Services.

Rely on trustworthy, consistent ETL solutions

• Enjoy the fastest ETL tool on the market.

• Customize how a package runs in different server environments and other circumstances.

• Secure and digitally sign packages for deployment.

• Easily install packages on a production system with a simple wizard.

• Gain checkpoint restart and transaction support, enabling resilient processes for execution.

• Take advantage of Windows Management Instrumentation listeners.

• Use flexible error-handling and event-driven features.

• Take advantage of integration with SQL Server Management Studio for simpler managing and monitoring of packages.

Integrate data sources and destinations

• Enable quick data access from multiple sources by using high-speed connectors.

• Access data in SAP, Teradata, OLE DB, text files, the Microsoft Entity Framework, and other common sources.

• Use built-in support for XML and web services to integrate service-oriented architectures and other nonstandard data sources.

• Rely on an optimized destination for data loading, including targeted SQL Server Compact databases.

• Load Reporting Services reports or Analysis Services cubes with metadata integration.

Support high-performance transformations out-of-the-box

• Obtain a scalable transformation engine that works with 32-bit and 64-bit architectures.

• Benefit from data and character conversions, calculated columns, and improved lookup performance.

• Manage conditional operations for partitioning and filtering.

• Take advantage of sorting, aggregation, and merges.

• Gain increased performance of highly parallel package designs and improved thread pooling.

Rapidly develop Integration Services packages with tools that developers already know.

Use a familiar and comprehensive development environment

• Integrate Business Intelligence Development Studio with Analysis Services and Reporting Services.

• Create shared solutions, including source control and metadata integration.

• Design, test, deploy, and maintain end-to-end business intelligence applications.

Manage visual debugging

• Depict the data pipeline at work in grids, graphs, and charts by using Data Viewers.

• Debug by using breakpoints, variable watches, and the call stack.

Go beyond simple ETL solutions by tapping the combined power of the Microsoft .NET Framework and SQL Server 2008 R2.

Extend integration capabilities

• Use the code design environment in Microsoft Visual Studio Tools for Applications.

• Write script tasks in Microsoft Visual C# .NET and Visual Basic .NET

• Seamlessly upgrade SQL Server 2005–based Visual Studio Tools for Applications script tasks.

• Code and distribute custom, reusable components.

Extend integration with data mining

• Build data-mining functionality into solutions by training models from integrated data.

• Apply data-mining models to data sources inside packages.

• Use predictive models to correct incomplete and missing data.

• Take advantage of association and clustering models to identify outliers and anomalies for data-quality issues.

• Capture data with rigorous audit and execution metadata.

Integrate with the community

• Join a dynamic and diverse community, from specialized software vendors to committed users.

• Easily develop and distribute advanced components.

• Share ideas, components, and support.