SSIS enables you to build the data lake of your dreams!
October 13, 2019

SSIS enables you to build the data lake of your dreams!

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

Overall Satisfaction with SQL Server Integration Services

The IT department at our organization uses SQL Server Integration Services. We use SSIS to perform extract, transform, and load (ETL) data operations. Our primary use is to move data from a source system or database, restructure the data to optimize it for reporting, and store it in a database instance used for reporting.
  • Handles multi-step, complex data moves.
  • Pulls from a variety of data sources.
  • Add-ons are readily available to extend their usefulness.
  • Integration with SQL Server and data tools.
  • The package publishing feature has gotten better over the years, but it could still be simplified.
  • Incorporating features from add-ons into the standard application would be helpful (mostly in relation to data sources).
  • Easier configurations for multiple publishing targets (dev/test/prod) with associated data connections.
  • By using SSIS, we have been able to eliminate simple, redundant data move operations that were conducted manually.
  • We have been able to build a stable data repository that combines data from different sources and provides a more holistic view of the business's data.
  • SSIS provided a flexible framework that we were able to use to connect to a variety of data sources--Oracle, SQL Server, Teradata, CSV, and web--which enabled us to build a system for business-critical reporting.
SQL Server is already in our wheelhouse so it only made sense to utilize the tools we already had available to us--SSIS, SSAS, & SSRS. Other non-technical users seem to be more comfortable using alternatives to SSIS. However, these alternatives are not as good as SSIS at building production-ready ETL processes.
I have never had to depend (or pay) for support on SSIS directly from Microsoft. There is a wide breadth of knowledge on SSIS in general and solving particular technical puzzles already available on the web. SSIS has been broadly adopted as the ETL tool of choice by many people and the users of its benefit from this expansive knowledgebase.

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

SSIS is well-suited for scheduled data loads, such as scraping web pages for currency rates or storm-related delivery delays and writing the results to an application database or copying transactional data from a source system, optimizing it for reporting, and writing to a reporting server. SSIS is also great in helping to combine data from disparate sources to build a deeper data analysis platform.

SSIS Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
10
Complex transformations
10
Data model creation
Not Rated
Metadata management
Not Rated
Business rules and workflow
9
Collaboration
7
Testing and debugging
8
Integration with data quality tools
Not Rated
Integration with MDM tools
Not Rated