SQL Server Integration Services

Microsoft SQL Server Integration Services provides a scalable enterprise data integration platform with exceptional Extract Transform and Load capabilities, enabling organisations to more easily manage data from a wide array of data sources.

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.
• New SSIS connectors for SAP BW, Oracle and Teradata.

 Want more information? - visit Microsoft

Integration Services at Work

• SQL Server Integration Services is the fastest ETL tool in the market underpinning a world class business intelligence platform.

Easily integrate diverse 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

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

Take advantage of a comprehensive development environment

• 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.

Extend integration with data mining

• 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