SSIS Just Works
February 17, 2020
SSIS Just Works
Score 8 out of 10
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?
Are you happy with SQL Server Integration Services's feature set?
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?
Would you buy SQL Server Integration Services again?
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.