SSIS Pros and Cons

SSIS Pros

GaryM
Data Architect at a non-profit with 1,001-5,000 employees
Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools.
View full review »
Vincent Diallo-Nort
student
It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud.
View full review »
Steve Seeber
Senior Director Business Intelligence with 201-500 employees
The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT.
View full review »

SSIS Cons

GaryM
Data Architect at a non-profit with 1,001-5,000 employees
You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price.
View full review »
Vincent Diallo-Nort
student
A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened.
View full review »
Steve Seeber
Senior Director Business Intelligence with 201-500 employees
I would like to see more standard components out of the box, such as SFTP, and Data Compression components.
View full review »
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: June 2019.
353,012 professionals have used our research since 2012.
Sign Up with Email