Try our new research platform with insights from 80,000+ expert users
SSIS Logo

SSIS pros and cons

Vendor: Microsoft
3.9 out of 5
Badge Leader
4,865 followers
Post review
 

SSIS Pros review quotes

GM
Aug 19, 2024
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.
it_user1048011 - PeerSpot reviewer
Jul 30, 2019
It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs.
Dhruv Singh - PeerSpot reviewer
Jul 25, 2023
The solution is easy to use and developer friendly.
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.
BobAmy - PeerSpot reviewer
Aug 21, 2023
Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows.
Rohit Rastogi - PeerSpot reviewer
Nov 17, 2022
It is easy to set up the product.
reviewer2305518 - PeerSpot reviewer
Nov 13, 2023
I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows.
Lucas Dreyer - PeerSpot reviewer
Jul 30, 2019
I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import.
Eyal Golombek - PeerSpot reviewer
Dec 8, 2022
The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work.
MJ
Nov 22, 2021
The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline.
LD
Sep 13, 2022
The performance is good.
 

SSIS Cons review quotes

GM
Aug 19, 2024
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.
it_user1048011 - PeerSpot reviewer
Jul 30, 2019
Improving the login procedure would make our reporting easier on monitoring our ETL processes.
Dhruv Singh - PeerSpot reviewer
Jul 25, 2023
There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us.
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.
BobAmy - PeerSpot reviewer
Aug 21, 2023
We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package.
Rohit Rastogi - PeerSpot reviewer
Nov 17, 2022
In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade.
reviewer2305518 - PeerSpot reviewer
Nov 13, 2023
We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse.
Lucas Dreyer - PeerSpot reviewer
Jul 30, 2019
This solution needs full support for real-time processing.
Eyal Golombek - PeerSpot reviewer
Dec 8, 2022
At one point, we did have to purchase an add-on.
MJ
Nov 22, 2021
It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well.
LD
Sep 13, 2022
Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options.