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
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?
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?
Yes
Did implementation of SQL Server Integration Services go as expected?
Yes
Would you buy SQL Server Integration Services again?
Yes