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

SSIS pros and cons

Vendor: Microsoft

3.8 out of 5

72 reviews
79% willing to recommend

4,866 followers

Pros & Cons summary

SSIS offers strong data integration capabilities, particularly excelling in automated ETL processes and complex data transformations. Compatible with Microsoft products, it integrates well but struggles with data sources like Salesforce and lacks Azure Data Factory support. While easy to set up and scalable, SSIS faces challenges in real-time processing, debugging, and technical documentation. Issues with performance, high pricing, and limited data lineage and profiling further impact its overall appeal for tech buyers.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

SSIS handles extensive ETL challenges and integrates well with Microsoft products.

It offers straightforward setup and deployment, supporting a variety of connectors and scripting languages.

SSIS provides efficient workflow and automation features, allowing independent code implementation and easy ETL solutions.

Its scalability is noteworthy, accommodating large datasets and diverse server types.

The ability to perform complex data transformations and integration is considered a key strength of SSIS.

CONS

Handling different data sources like Salesforce and Oracle Cloud needs improvement, and changing metadata sources significantly impacts the ETL process.

Debugging and technical documentation require significant enhancement as current documentation is lacking, leading to difficulties in error resolution.

Integration with Informatica and other platforms is challenging, with concerns over data lineage, requiring extensive ETL rework.

Performance is not as high as competitors in the market, with stability issues especially when handling extensive ETL data processing.

Support for additional programming languages and improved integration with tools like Power BI and Azure Data Factory is needed.

SSIS Pros review quotes

GM

Data Architect at World Vision

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.

Read full review

Senior BI Developer at a music company with 501-1,000 employees

Jul 30, 2019

It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs.

Read full review

Senior Architect (Data and AI) at a tech services company with 1,001-5,000 employees

Jul 25, 2023

The solution is easy to use and developer friendly.

Read full review

Free Report: SSIS Reviews and More

Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.

824,053 professionals have used our research since 2012.

Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

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.

Read full review

Lead Data Engineer at Capgemini

Nov 17, 2022

It is easy to set up the product.

Read full review

reviewer2305518

Business Intelligence Architect at a financial services firm with 5,001-10,000 employees

Nov 13, 2023

I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows.

Read full review

Data Engineer at BBD

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.

Read full review

Database administrator at a recruiting/HR firm with 51-200 employees

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.

Read full review

MJ

Muhammad Arif Javed

Senior Manager Software Development at Techlogix

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.

Read full review

LD

Information Technology Division Director at Ethiopian Roads Administration

Sep 13, 2022

The performance is good.

Read full review

Show 10 more reviews (out of 66)

SSIS Cons review quotes

GM

Data Architect at World Vision

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.

Read full review

Senior BI Developer at a music company with 501-1,000 employees

Jul 30, 2019

Improving the login procedure would make our reporting easier on monitoring our ETL processes.

Read full review

Senior Architect (Data and AI) at a tech services company with 1,001-5,000 employees

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.

Read full review

Free Report: SSIS Reviews and More

Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.

824,053 professionals have used our research since 2012.

Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

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.

Read full review

Lead Data Engineer at Capgemini

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.

Read full review

reviewer2305518

Business Intelligence Architect at a financial services firm with 5,001-10,000 employees

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.

Read full review

Data Engineer at BBD

Jul 30, 2019

This solution needs full support for real-time processing.

Read full review

Database administrator at a recruiting/HR firm with 51-200 employees

Dec 8, 2022

At one point, we did have to purchase an add-on.

Read full review

MJ

Muhammad Arif Javed

Senior Manager Software Development at Techlogix

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.

Read full review

LD

Information Technology Division Director at Ethiopian Roads Administration

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.

Read full review

Show 10 more reviews (out of 66)

Product Categories

Product Categories

Data Integration

Popular Comparisons

Popular Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs SSIS

Azure Data Factory vs SSIS

Informatica PowerCenter vs SSIS

Teradata vs SSIS

Oracle Data Integrator (ODI) vs SSIS

Talend Open Studio vs SSIS

IBM InfoSphere DataStage vs SSIS

Oracle GoldenGate vs SSIS

Palantir Foundry vs SSIS

SAP Data Services vs SSIS

Qlik Replicate vs SSIS

Alteryx Designer vs SSIS

Fivetran vs SSIS

SnapLogic vs SSIS

See all alternatives

Product Categories

Product Categories

Data Integration

Popular Comparisons

Popular Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs SSIS

Azure Data Factory vs SSIS

Informatica PowerCenter vs SSIS

Teradata vs SSIS

Oracle Data Integrator (ODI) vs SSIS

Talend Open Studio vs SSIS

IBM InfoSphere DataStage vs SSIS

Oracle GoldenGate vs SSIS

Palantir Foundry vs SSIS

SAP Data Services vs SSIS

Qlik Replicate vs SSIS

Alteryx Designer vs SSIS

Fivetran vs SSIS

SnapLogic vs SSIS

See all alternatives

Related questions

51

Which ETL or Data Integration tool goes the best with Amazon Redshift?

191

Which ETL tool would you recommend to populate data from OLTP to OLAP?

87

Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?

543

What Is The Biggest Difference Between Informatica PowerCenter and Microsoft SSIS?

192

What is the biggest difference between SSIS and Pentaho?

346

What are the pros and cons of SSIS?

71

Which is better - SSIS or Informatica PowerCenter?

38

When evaluating Data Integration, what aspect do you think is the most important to look for?

87

Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?

140

What are the best on-prem ETL tools?