SSIS Review

Offers good data integration but there was an incident where data extraction crashed

What is most valuable?

It has good data integration and good processes. 

What needs improvement?

I would like to see an auto-scheduler feature in the Developer version of this solution.

I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process. 

For how long have I used the solution?

I have been using this solution for the last three years.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

Compared to other solutions, this solution is scalable. 

We only have three users using this solution. 

How are customer service and technical support?

We haven't had to use their technical support. We don't really have any issues. We only had a problem with the data extraction. 

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

This is the first tool of this sort that we've used in my company. 

How was the initial setup?

The initial setup was complex. 

What about the implementation team?

We implemented it ourselves. We did the ATL. It was nice in the previous version. There was an issue where we were extracting a big load of data and the system crashed. 

What other advice do I have?

I would rate it a seven out of ten. Not a ten because of the data extraction that crashed. Tableau is better in this aspect. The transformation of data is very good in SSIS. 

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
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: April 2021.
501,151 professionals have used our research since 2012.
Add a Comment