SSIS Review

An inexpensive tool with a short learning curve

What is our primary use case?

The primary use case for this solution varies according to the customer, but it typically involves moving data from OLTP systems into a data warehouse and/or data marts.

How has it helped my organization?

This solution has provided an inexpensive tool and it is easy to find experienced developers.

What is most valuable?

The most valuable features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT.

What needs improvement?

The UI could use refinement. I would like to see more standard components out of the box, such as SFTP, and data compression components.

For how long have I used the solution?

More than five years.
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment