SSIS Just Works
February 17, 2020

SSIS Just Works

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

Overall Satisfaction with SQL Server Integration Services

SSIS is being used for data interchange. This includes using it for traditional ETL to a corporate data warehouse, as well as for the production or intake of flat files for interchange with external sources. Sources include traditional RDBMS, web services based cloud sources, and flat files. We are beginning the process of extending SSIS to the cloud in conjunction with Azure Data Factory.
  • Process flow.
  • Connection to a wide array of sources.
  • Built-in upsert component.
  • Better operability with source control systems.
  • Consolidation into a standard tool for data movement makes maintenance and administration easier.
  • The extensibility of the tool has allowed us to fill the gaps with 3rd party add-ons.
I personally prefer SSIS. There are items that each do better than the others, but the ease of use of SSIS, along with its extensibility to 3rd party, ability to write any code required in the tool, and uses the same IDE for the MS BI suite (more of an issue if you're not a pure ETL developer) place it ahead of Informatica and Ab Initio. I would give credit to Ab Initio for having the overall most approachable interface despite being a niche tool.
It's Microsoft support. I've found it to be generally good, once you get to the right person. The community is huge, so most of your questions will have been asked and answered on at least one of the major tech boards. MS has continually improved the product since its inception in 2005. Overall they've done a great job since the humble beginnings of DTS.

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

Yes

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

Yes

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?

Yes

Would you buy SQL Server Integration Services again?

Yes

SSIS works great for 80+ percent of ETL use cases. It is particularly well suited for migrating and transforming data between traditional databases. If using the Azure cloud, it also has a number of built-in components to make that process easier. The base set of transforms are pretty robust and will perform most tasks with decent speed.

SSIS Feature Ratings

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