SQL Server Integration Services: a great tool for small to medium sized implementations
January 15, 2019
SQL Server Integration Services: a great tool for small to medium sized implementations

Score 6 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
SSIS is used within my organization to move data from one data source to another, performing data translations, transformations, lookups and calculations during the data movement. This process often includes very complex data transformation processes including the use of APIs, external references and various class libraries. SSIS is currently used in various areas across the entire organization to solve SQL server-based data transformation issues.
Pros
- It handles SQL Server databases flawlessly
- It provides a robust developer interface
- It allows a developer to encapsulate complex scripts directly within an SSIS project or reuse scripts across projects
- It interfaces quite well with a large number of available libraries
Cons
- SSIS memory usage can be quite high particularly when SSI and SQL server are on the same machine
- SSIS is not available on any environment other than Microsoft Windows
- SSIS does not function with any database engine back-end other than Microsoft SQL Server
- SQL Server Integration Services has had a positive impact on our organization as it has allowed us to integrate data from external data sources via CSV and flat files
- SQL Server Integration Services has a waning positive impact on our organization as we are moving more toward Big Data and Oracle data
- Given the initial investment in SQL Server Integration Services, the ROI has been positive as it has enabled business-critical ETL for the past 5 years
SQL Server Integration Services does a good job for our SQL Server environments and was selected for that reason. For a SQL Server-only implementations, I would recommend SQL Server Integration Services. When we compared SSIS to other ETL providers against SQL Server, SSIS was the logical choice. It is well integrated not only with the database but with Visual Studio and the entire Microsoft development suite.
Comments
Please log in to join the conversation