SSIS offers what I need for data processing.
July 19, 2017

SSIS offers what I need for data processing.

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

Overall Satisfaction with SQL Server Integration Services

In my current organization, SSIS is being used by the enterprise data warehouse team. This team uses SSIS to construct data warehouse, prepare data cubes, and fulfill ad-hoc data-related acquisitions.
  • Presents the flow of data processing very well, making it easy to learn/understand SSIS packages.
  • T-SQL and C# friendly.
  • Comprehensive configuration, logging, and error handling.
  • Some components are not working very well, including sorting, SCD, etc.
  • Different components could have different syntax or data type definition.
  • Not enough scripting learning materials.
  • Various data requests have been fulfilled without much hazard using SSIS (data processing, ETL job, schedules, etc.)
  • Data related standards have been enforced on SSIS development methodology so that data quality has been improved.
  • Advanced features have been implemented using SSIS (e.g. FTP file notification) to automate some of the manual work.
Unfortunately SSIS is the only ETL tool I have used by far. I used Dundas BI before, didn't like its ETL component, but that is more of a data visualization tool.
For SQL Server users, SSIS would be a natural yet very wise choice. It works quite well with Microsoft bottom layer and offers an easy and more user-friendly way of manipulating data.

SSIS Feature Ratings

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