SSIS Review

Fast insert, fuzzy logic matching, and free for developers to learn on

What is our primary use case?

We use this solution to ingest data to a data lake that is built on SQL Server.

How has it helped my organization?

SSIS seems easy to use, is freely available for programmers to learn on their own, and has a lot of resources on the web for any trouble you get into.

What is most valuable?

The most valuable features of this solution are the fast insert and fuzzy logic matching.

What needs improvement?

This may be done, but upgrades to new versions required re-implementing each package.  This is worse for us because we have about one thousand SSIS packages. Hopefully they are now allowing backwards compatibility.

Generic processes should be used instead of custom code for each table.

For how long have I used the solution?

I have been using this solution for fifteen years.
**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 Talend Data Fabric
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: August 2021.
533,638 professionals have used our research since 2012.
Add a Comment
ITCS user