SSIS Review

The drag and drop feature makes it an easy to use solution and it has a good user experience

What is our primary use case?

We use the on-prem version of this solution. Our primary use case of this solution is for integrated data on the SQL server. 

What is most valuable?

It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft.

What needs improvement?

There are a lot of features that could make this solution better. 

There were some issues when we tried to connect it to data storage. It was a connection issue. There is also room for improvement in the underlying language. 

For how long have I used the solution?

I have been using this solution for three to four months.

What do I think about the stability of the solution?

It is stable. 

What do I think about the scalability of the solution?

From personal experience, I really can't comment on the scalability, but from what I've seen online, and what I heard from other people is that it scales quite nicely.

How are customer service and technical support?

I haven't had to contact technical support. 

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

We previously used an in-house solution based on Oracle APEX.

How was the initial setup?

The initial setup was straightforward.

What about the implementation team?

We used a consultant for the integration.

Which other solutions did I evaluate?

We chose SSIS because it was a good financial decision. It was the most cost-effective option at the time. 

There are many projects for the company that I work for that requires implementation for a client. I started with it because I just wanted to learn about it, and I had the chance to use it because there was an opportunity that opened up to implement it.

What other advice do I have?

If you have data needs and you are a small or medium enterprise this is a good solution. If you are an organization and you're not dealing with terabytes of data, but you still need to analyze data to make that decision, you should go with this solution.

I would rate it a 7.5 out of ten. 

**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,818 professionals have used our research since 2012.
Add a Comment