SSIS Pros and Cons

SSIS Pros

GaryM
Data Architect at World Vision
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 »
SeniorBI67
Senior BI Developer at a music company with 501-1,000 employees
It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs.
View full review »
reviewer860583
Data Scientist at a tech vendor with 501-1,000 employees
I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import.
View full review »
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: March 2020.
406,607 professionals have used our research since 2012.
AhmedShaban
Database Consultant
The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great.
View full review »
Alireza Nikseresht
CEO at Shiraz University
It's already very user-friendly and has a good dashboard.
View full review »
Globalmark677
Platform Lead: Global Markets Data Analytics at Rand Merchant Bank
Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture.
View full review »
AltanAtabarut
Founding Partner at Altdata Analytics
With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server.
View full review »
Sherif Abdelrehim
Data Architect and Modeler at a tech services company with 201-500 employees
The initial setup of this solution is very straightforward.
View full review »
BIConsule1f7
BI Consultant at a tech services company with 201-500 employees
It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft.
View full review »
Prodown567
Technical Product Owner, Team Lead at ARCA
The setup is straightforward. It's very easy to install.
View full review »

SSIS Cons

GaryM
Data Architect at World Vision
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 »
SeniorBI67
Senior BI Developer at a music company with 501-1,000 employees
Improving the login procedure would make our reporting easier on monitoring our ETL processes.
View full review »
reviewer860583
Data Scientist at a tech vendor with 501-1,000 employees
This solution needs full support for real-time processing.
View full review »
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: March 2020.
406,607 professionals have used our research since 2012.
AhmedShaban
Database Consultant
There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon.
View full review »
Alireza Nikseresht
CEO at Shiraz University
Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases.
View full review »
Globalmark677
Platform Lead: Global Markets Data Analytics at Rand Merchant Bank
We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage.
View full review »
AltanAtabarut
Founding Partner at Altdata Analytics
The solution should work on the GPU, graphical processing unit. There should also be piping integration available.
View full review »
Sherif Abdelrehim
Data Architect and Modeler at a tech services company with 201-500 employees
The performance of this solution is not as good as other tools in the market.
View full review »
BIConsule1f7
BI Consultant at a tech services company with 201-500 employees
There were some issues when we tried to connect it to data storage. It was a connection issue.
View full review »
Prodown567
Technical Product Owner, Team Lead at ARCA
Video training would be a helpful addition.
View full review »
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: March 2020.
406,607 professionals have used our research since 2012.