SSIS Reviews

190 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.0 out of 101

Do you work for this company?

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-8 of 8)

Steven Gockley, MBA, MCSA profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source

Usability

9
If you use any of the Microsoft tools, it is easy to get using and understand since it uses Visual Studio and SSMS to work with. There are extensions you can get and some of those can be difficult to work with but usually they slide in nicely. The one thing to understand though is there is some installation and configuration on the SQL Server side that can take some time.
Read Steven Gockley, MBA, MCSA's full review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source

Usability

10
While there is a learning curve, it is possible to successfully implement SSIS in anyone's business with little or no prior experience. The tool's native usability along with a wealth of online resources in a large community means that the user will never be stuck for long.

Read this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source

Usability

9
SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.
Read this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source

Usability

8
SSIS has a drag and drop based developer interface, so it is relatively straight forward to get started. You can start to get into the weeds pretty quickly as your solution becomes more complex. However, most of the base functions are right in front of you for a developer. You can also set project and solution level parameters, so when you deploy to new environments, you don't have to jump into each package to change your variables and settings. (For example, default directory to ingest flat files).
Read this authenticated review
No photo available
Score 6 out of 10
Vetted Review
Verified User
Review Source

Usability

6
SQL Server Integration Services is a relatively nice tool but is simply not the ETL for a global, large-scale organization. With developing requirements such as NoSQL data, cloud-based tools, and extraordinarily large databases, SSIS is no longer our tool of choice.
Read this authenticated review
Luca Campanelli profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source

Usability

8
in terms of usability, sql server integration services is very schematic and very little dynamic, but for the type of software this schematic is physiological.
When you gain the right technical expertise and once you really know the product usability becomes increasingly fast and simple, the important thing is not to be scared on the first approach.
Read Luca Campanelli's full review

Feature Scorecard Summary

Connect to traditional data sources (32)
9.5
Connecto to Big Data and NoSQL (25)
7.5
Simple transformations (32)
9.9
Complex transformations (32)
8.1
Data model creation (16)
7.1
Metadata management (20)
6.2
Business rules and workflow (25)
8.0
Collaboration (24)
6.1
Testing and debugging (30)
7.2
Integration with data quality tools (23)
8.4
Integration with MDM tools (23)
7.4

About SSIS

Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
Categories:  Data Integration

SSIS Technical Details

Operating Systems: Unspecified
Mobile Application:No