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

SSIS pros and cons

Vendor: Microsoft

3.8 out of 5

76 reviews
80% willing to recommend

Pros & Cons summary

SSIS delivers robust ETL capabilities, enabling DBA tasks, scripting, and cloud deployment via Data Factory. Integration with Microsoft products enhances compatibility and performance across platforms. Write custom SQL and C# code for flexible data workflows. Challenges exist with connectivity to Salesforce and Oracle Cloud, lack of Power BI and Azure Data Factory integration, and inefficient debugging. Users seek better real-time processing, more components, and improved graphical mapping.

Buyer's Guide

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

Prominent pros & cons

PROS

SSIS offers robust ETL capabilities, allowing tasks such as DBA activities, scripting, and cloud deployment via Data Factory.

The automation capabilities, including BIML add-in for SSDT and fast insert and fuzzy logic matching, are highly valuable.

Compatibility with Microsoft products enhances usability and integration across multiple platforms.

SSIS supports easy data integration from various data sources, enabling complex transformations with outstanding performance and scalability.

The ability to write custom SQL and C# code within SSIS packages facilitates flexible and customized data workflows.

CONS

SSIS struggles with connectivity to various data sources such as Salesforce and Oracle Cloud, and lacks integration with tools like Power BI and Azure Data Factory.

The debugging process in SSIS is inefficient, often requiring extensive consultation of documentation to resolve errors.

Many users find SSIS cumbersome for mapping data graphically and would benefit from scripting options to simplify this process.

SSIS lacks comprehensive support for real-time processing and scaling options.

The addition of more standard out-of-the-box components, such as those for data compression and connection tools, is needed to enhance functionality.

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

RH

Assistant Manager at a tech services company with 10,001+ employees

Jun 19, 2017

In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc.

Read full review

VD

Vincent Diallo-Nort

student at University of Newcastle

Jul 9, 2018

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.

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: December 2025.

880,490 professionals have used our research since 2012.

Senior Director Business Intelligence at Xtivia

May 1, 2019

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

Read full review

AN

Alireza Nikseresht

CEO at Shiraz University

Jul 18, 2019

It's already very user-friendly and has a good dashboard.

Read full review

Elena Tejadillos

IT Officer in Data Science at United Nations

Jul 28, 2019

There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information.

Read full review

SP

Sasidhar Parupudi

Principle Consultant at Keyrus South Africa

Jul 29, 2019

The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions.

Read full review

Platform Lead: Global Markets Data Analytics at Rand Merchant Bank

Jul 29, 2019

Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture.

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

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

Show 10 more reviews (out of 70)

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

RH

Assistant Manager at a tech services company with 10,001+ employees

Jun 19, 2017

SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc.

Read full review

VD

Vincent Diallo-Nort

student at University of Newcastle

Jul 9, 2018

A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened.

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: December 2025.

880,490 professionals have used our research since 2012.

Senior Director Business Intelligence at Xtivia

May 1, 2019

I would like to see more standard components out of the box, such as SFTP, and Data Compression components.

Read full review

AN

Alireza Nikseresht

CEO at Shiraz University

Jul 18, 2019

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.

Read full review

Elena Tejadillos

IT Officer in Data Science at United Nations

Jul 28, 2019

The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information.

Read full review

SP

Sasidhar Parupudi

Principle Consultant at Keyrus South Africa

Jul 29, 2019

I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use.

Read full review

Platform Lead: Global Markets Data Analytics at Rand Merchant Bank

Jul 29, 2019

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.

Read full review

Data Engineer at BBD

Jul 30, 2019

This solution needs full support for real-time processing.

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

Show 10 more reviews (out of 70)

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

Palantir Foundry vs SSIS

Oracle Data Integrator (ODI) vs SSIS

Qlik Talend Cloud vs SSIS

IBM InfoSphere DataStage vs SSIS

Oracle GoldenGate vs SSIS

SAP Data Services vs SSIS

Fivetran vs SSIS

Qlik Replicate vs SSIS

SnapLogic vs SSIS

Spring Cloud Data Flow 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

Palantir Foundry vs SSIS

Oracle Data Integrator (ODI) vs SSIS

Qlik Talend Cloud vs SSIS

IBM InfoSphere DataStage vs SSIS

Oracle GoldenGate vs SSIS

SAP Data Services vs SSIS

Fivetran vs SSIS

Qlik Replicate vs SSIS

SnapLogic vs SSIS

Spring Cloud Data Flow vs SSIS

See all alternatives

Related questions

47

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

62

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

56

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

81

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

35

What is the biggest difference between SSIS and Pentaho?

56

What are the pros and cons of SSIS?

38

Which is better - SSIS or Informatica PowerCenter?

33

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

56

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

361

What are the best on-prem ETL tools?