SQL Server Integration Services Review
June 23, 2022

SQL Server Integration Services Review

Chris Guru | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Server Integration Services

We are in the middle of data Migration projects from Legacy to Cloud (Azure). The SQL Server Integration Services provides the solution that we need specifically for this project objective where we can handle source and landed data as when needed. It's a competent product from Microsoft that supports and integrates well with other Microsoft tools to meet our project objectives, and goals.
  • It's user friendly and Microsoft provides good technical support as well.
  • Since its from Microsoft, The Integration of other Microsoft tools are quite easy.
  • Can get the data from any sources and dump/land anywhere you wish as you need.
  • The data source other than Microsoft-based applications could be improved to a better extent.
  • Sometimes we need other tools for Data conversions, which could be in-build or capabilities that needs an improvement.
  • The user interface can be better as sometime it lags with error.
  • We are on a Data Migration project of huge scale from Legacy to Cloud. So it does help a great deal to us and definitely gives us better ROI.
  • The data model, analysis with this will helps us to have better product portfolio's and for research purpose as well on business.
  • Not much negative to point out though it can be improved on Big data ETL and some UI.
Not used any other integration applications other than SQL Server Integration service's yet but for me, in most areas SSIS stands out for the business needs and meets its objectives definitely few things can be improved such as most of the automation, conversion, timing of ETL on data Migration, etc.

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?

I wasn't involved with the selection/purchase process

Did implementation of SQL Server Integration Services go as expected?

I wasn't involved with the implementation phase

Would you buy SQL Server Integration Services again?

Yes

SQL Server, It's the tool for querying and it's better to go and create stored procedures, table/objects, or query any table from any database. The User Interface It provides is really good and easy to get started. In SSIS we can query create logics and export the result into such as CSV for data analysis. It serves a great purpose for the data migrations projects. And there is room for improvements in its automation capabilities were something we are doing manually such as we have to load CSV files one by one and not in one go.

SSIS Feature Ratings

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