SSIS had its day, but in the big leagues it can no longer play
June 29, 2022

SSIS had its day, but in the big leagues it can no longer play

Alex Bransky | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Server Integration Services

SSIS pulls data from various locations (mostly SQL Server instances but also some flat files and SFTP), mainly for transforming the data and putting it in the data warehouse.
  • SSIS is good for small, simple data syncs.
  • SSIS is good for moving data quickly into SQL Server (good batch performance).
  • Very hard to diff for code review when changes are made.
  • Very buggy IDE (freezes in Visual Studio, doesn't always show what's in the underlying XML properly)
  • Lacking lots of features or more modern tools, like ability to monitor for changes to the source schema and apply them to the target.
  • SSIS provided good value when there were few competitors, for somebody already using SQL Server Enterprise Edition.
Fivetran, Stitch, and Etleap are all 1000x more modern than SSIS and 100x less aggravating. While those tools are mainly used to sync data rather than transform it, the ELT model works much better than the ETL model in most situations.

Do you think SQL Server Integration Services delivers good value for the price?

No

Are you happy with SQL Server Integration Services's feature set?

No

Did SQL Server Integration Services live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of SQL Server Integration Services go as expected?

No

Would you buy SQL Server Integration Services again?

No

If you already have licenses for SQL Server and need to get data from A to B, especially if A and/or B is SQL Server, then SSIS could be a reasonable choice, especially if you can't use a cloud tool like Fivetran due to security concerns.

SSIS Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
1
Simple transformations
5
Complex transformations
5
Data model creation
Not Rated
Metadata management
1
Business rules and workflow
Not Rated
Collaboration
1
Testing and debugging
3
feature 1
Not Rated
Integration with data quality tools
Not Rated
Integration with MDM tools
2