SSIS – SQL Server Integration Services connect and transform disparate data sources. Gain a scalable enterprise data integration platform with exceptional extract, transform, and load (ETL) and integration capabilities by using Microsoft SQL Server R2 Integration Services.
- Write script tasks with Microsoft Visual C# and Microsoft Visual Basic .NET.
- Work with the ADO.NET for source and destination components.
- Use thread pooling and enhanced lookup transformations.
- Take advantage of the improved Import and Export Wizard.
Creating process flow for data through your organization can be one of the most challenging tasks. SQL Server Integration Services (SSIS) helps you with a robust enterprise-class data integration application. Source: microsoft.com.
Download a thorough comparison of SQL Server Integration Services (SSIS) between 18 other ETL tools in the ETL Tool Survey Report.