SQL Server Integration Services is one of the best ETL tools out there
October 28, 2015

SQL Server Integration Services is one of the best ETL tools out there

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Software Version

2012

Overall Satisfaction with SQL Server Integration Services

We use SQL Server Integration Services for Cube processing. It's being used by my department.
  • Cube processing packages
  • ETL
  • DBA tasks
  • Metadata Management
  • Big Data support
  • Increased development efficiency
  • Very fast data load
  • Better SLA
SQL Server Integration Services is a very easy to learn, cost effective and efficient tool.
It works really well with other Microsoft products like SQL server and SSAS.

SSIS Feature Ratings

Connect to traditional data sources
8
Connecto to Big Data and NoSQL
4
Simple transformations
9
Complex transformations
8
Data model creation
8
Metadata management
6
Business rules and workflow
7
Collaboration
7
Testing and debugging
6
Integration with data quality tools
9
Integration with MDM tools
8