SSIS Review

Excellent automated workflow and functionality

What is our primary use case?

We primarily use the solution for integration packages for ETL in order to build data warehouses.

What is most valuable?

The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent.

What needs improvement?

The solution should offer more information online for users of SSIS. There are only a few general data sources available, but it would be helpful if there was more extensive information.

The solution could also use some more intelligent discs for data manipulation, or maybe some artificial intelligence as well. It needs more integration tools, so you can connect to different sources.

For how long have I used the solution?

I've been using the solution since 2008.

What do I think about the stability of the solution?

The solution is quite stable.

What do I think about the scalability of the solution?

The solution is very scalable. The amount of people that use SSIS from our end depends on the project, so it varies. We increase the usage of this product based on the projects that we get. Basically, each project that we do, we use this solution for integration purposes.

How are customer service and technical support?

Technical support is quite good.

Which solution did I use previously and why did I switch?

I've always used SSIS. We never considered any other solution. We might have used some tools that were developed in-house occasionally, but by and large, we always use SSIS.

How was the initial setup?

The initial setup was straightforward.

What other advice do I have?

We use the on-premises version of the solution.

I would recommend the solution to others. I'd give it a rating of eight out of ten.

**Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
More SSIS reviews from users
...who work at a Financial Services Firm
...who compared it with Informatica PowerCenter
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2021.
475,705 professionals have used our research since 2012.
Add a Comment