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.
Add a Comment
Guest