SSIS Review

In addition to the ETL challenges, it allows us to do DBA activitities, scripting and many other tasks.

How has it helped my organization?

For the full version of the SQL Server, SSIS, SSAS and SSRS will come as additional features for free. Hence, my organization need not spend extra money for other ETL, reporting and analysis tools. This can give very good flexibility.

What is most valuable?

In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc.

What needs improvement?

SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc. Also, handling of the different data types will be a big challenge here; so expecting improvement in these areas.

What do I think about the stability of the solution?

There were no stability issues.

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and technical support?

Technical support is very good.

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

Based on the client's requirements, we switched over to this solution.

How was the initial setup?

The setup is straightforward.

Which other solutions did I evaluate?

We looked at Informatica and DataStage.

What other advice do I have?

Don't worry, go ahead.

**Disclosure: My company has a business relationship with this vendor other than being a customer:
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: June 2021.
521,189 professionals have used our research since 2012.
Add a Comment
ITCS user
1 Comment

author avatarBrian Dandeneau
Top 5LeaderboardConsultant

Thanks for the review and keep them coming.

I like what you put in here for improvements. However, don't hold your breath for Oracle Cloud integration. Most Oracle ETL/ELT tools don't have direct cloud integration yet and its not on the roadmap for a few years.
Brian Dandeneau
CEO Applied Governance