Integration

Integration Services

Microsoft® SQL Server® 2008 provides a scalable enterprise data integration platform with exceptional ETL and integration capabilities, enabling organizations to more easilymanage data from a wide array of data sources.
http://www.microsoft.com/sqlserver/2008/en/us/integration.aspx

ENTERPRISE-READY PLATFORM

TOP NEW FEATURES


Create Script tasks by using ®Microsoft Visual C# and ® Microsoft Visual Basic .NET. Use ADO.NET for tasks as well as for source and destination components. Improve scalability with thread pooling and enhanced lookup transformations.Perform more functional and scalable data transfers with the improved SQL Server Import and Export Wizard.

Use the SQL Server Integration Services platform to build enterprise-class dataintegration solutions. Deploy trustworthy and reliable ETL solutions Use package configurations to customize the way a package runs in different circumstances, such as for different server environments. Secureand digitally sign packages for deployment, and then easily install them on a production system by using a simple wizard. Enable resilient processes for unattended execution by using checkpointrestart and transaction support, together with WMI listeners and flexible error-handling and eventdriven features. Take advantage of the integration of SQL Server Integration Services (SSIS) with SQL ServerManagement Studio to simplify the management and monitoring of packages in the SQL Server ecosystem. Build efficient ETL solutions Use the change data capture capabilities of SQL Server 2008 tooptimize extract, transform, and load
SQL Server 2008 Integration Services

(ETL) operations by refreshing only data that has changed since the previous iteration. Use the improved SQL Server Import andExport Wizard to perform more functional and scalable data transfers. Easily integrate diverse data sources and destinations Access data in SAP and other common sources, including text files,...