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
Review Source

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
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools