SSIS Reviews

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

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-6 of 6)

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

Performance

8
Raw performance is great. At times, depending on the machine you are using for development, the IDE can have issues. Deploying projects is very easy and the tool set they give you to monitor jobs out of the box is decent. If you do very much with it you will have to write into your projects performance tracking though.
Read Steven Gockley, MBA, MCSA's full review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source

Performance

9
I haven't experienced any issues worth mentioning in terms of SSIS performance. But it is worth mentioning that there is a HUGE difference between tools and with different configurations within the app. I've seen a single data flow task go from over 30 minutes to less than one with the right configuration.

There should be more tools to enable process tuning to improve package performance.... although the software itself runs smoothly with very few interruptions.
Read this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source

Performance

9
SSIS packages tend to run, anecdotally, slower than expected in large volume data processing environments and is sometimes better used to prototype high-performance workloads than the execute them. This is a classic case of "your mileage may vary" in a sense that for most workloads I have experienced SSIS has proven more than fast enough to get the job done. In one case, one where live web server data was being streamed into SQL Server in a web-scale ad serving system, SSIS was clearly not fast enough to keep up at any scale--and this was a very rare case.
Read this authenticated review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source

Performance

10
You can, of course, accidentally make sloppy code or workflows but it’s not a tools issue if you run packages in an inefficient way. With a company of our size, we never had any performance issues but I can imagine for larger companies that this will have a greater focus.
Read this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source

Performance

8
Performance is relative to how you implement your solutions. Proper architecture and design are crucial regardless of what tool you select for your data solutions. That being said, SSIS performs relatively well from a performance standpoint.
Read this authenticated review
No photo available
Score 6 out of 10
Vetted Review
Verified User
Review Source

Performance

6
SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
Read this authenticated review

Feature Scorecard Summary

Connect to traditional data sources (34)
9.5
Connecto to Big Data and NoSQL (26)
7.6
Simple transformations (34)
9.9
Complex transformations (33)
8.2
Data model creation (17)
7.4
Metadata management (21)
6.7
Business rules and workflow (27)
8.2
Collaboration (25)
6.3
Testing and debugging (32)
7.4
feature 1 (1)
7
Integration with data quality tools (24)
8.6
Integration with MDM tools (24)
7.5

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