Rapid and low cost integration with various sources for a DW
June 25, 2022

Rapid and low cost integration with various sources for a DW

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

Overall Satisfaction with SQL Server Integration Services

We use SQL Server Integration Services (SSIS) as part of our on-premise Data Warehouse architecture. We have an ELT pattern and SSIS is used almost exclusively for the Extract and Load steps. Almost all packages are generated using BIML (Business Intelligence Markup Language) as a means of templating and then scripting them.
  • Easily connect with a wide variety of sources.
  • Provide control and flow to job execution order.
  • Able to extend functionality through scripting tasks.
  • Not flexible when source/target tables and file formats change.
  • Inflexible with regards to varying data types when Excel spreadsheets are used as a source or columns are added (as per previous item).
  • Occasional issues around mixed development and production x86/x64 run times can be frustrating.
  • Rapid integration with source systems has provided a high ROI however this is based on using BIML in conjunction with SSIS.
  • Combination of workflow, data manipulation and scripting make it a very capable data integration tool.
Low-cost relative to other products - in fact, zero cost if one is considering the license cost as being for the database engine with Integration Services added on. It has a comparable range of functionality and performance and as such it's a 'no-brainer' to use SSIS over other data integration tools.

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?


Did implementation of SQL Server Integration Services go as expected?


Would you buy SQL Server Integration Services again?


I do not think that SQL Server Integration Services (SSIS) is great for complex dependency management and scheduling for an entire DW load. However, it is great for smaller units of work and particularly where moving data between systems is required due to its extensive and extensible connectivity options. That said, it is obviously focused on traditional on-premise systems and cloud-based environments are likely to prefer using the next-generation version of SSIS being Azure Data Factory (ADF).

SSIS Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Testing and debugging