No more typing reviews! Try our Samantha, our new voice AI agent.

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

Developer at a tech consulting company with 51-200 employees

Sep 15, 2014

Microsoft SQL Server Integration Services is one of the most effective ETL tools available in the market.

Read full review

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 Consultant with 51-200 employees

Sep 23, 2015

Its easy to use, fast to develop.

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: March 2026.

885,667 professionals have used our research since 2012.

Business Intelligence Consultant at a tech services company with 51-200 employees

Sep 14, 2015

Compatibility with the rest of Microsoft BI stack

Read full review

BD

Brian Dandeneau

Business Process and Strategy Specialist Advisor at NTTData

Apr 29, 2019

The packaging and how it is organized is good for someone that really has never seen ETL before.

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

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

Show 10 more reviews (out of 74)

SSIS Cons review quotes

Developer at a tech consulting company with 51-200 employees

Sep 15, 2014

Need to improve error logging although it does provide error logs but there is still more room for improvement in this area.

Read full review

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 Consultant with 51-200 employees

Sep 23, 2015

Scalability not on the same level as with IBM Datastage.

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: March 2026.

885,667 professionals have used our research since 2012.

Business Intelligence Consultant at a tech services company with 51-200 employees

Sep 14, 2015

Upgrading is usually painful and time consuming despite what MS says

Read full review

BD

Brian Dandeneau

Business Process and Strategy Specialist Advisor at NTTData

Apr 29, 2019

Again it failed a lot and by a lot I mean every day. The failures were false alarms and caused many sleepless night for our company that I used to work for.

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

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

Show 10 more reviews (out of 74)

Product Categories

Product Categories

Data Integration

Popular Comparisons

Popular Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs SSIS

Teradata vs SSIS

Informatica PowerCenter vs SSIS

Azure Data Factory vs SSIS

Palantir Foundry vs SSIS

Qlik Talend Cloud vs SSIS

Oracle Data Integrator (ODI) vs SSIS

Fivetran vs SSIS

Oracle GoldenGate vs SSIS

IBM InfoSphere DataStage vs SSIS

SnapLogic vs SSIS

SAP Data Services vs SSIS

Qlik Replicate vs SSIS

See all alternatives

Product Categories

Product Categories

Data Integration

Popular Comparisons

Popular Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs SSIS

Teradata vs SSIS

Informatica PowerCenter vs SSIS

Azure Data Factory vs SSIS

Palantir Foundry vs SSIS

Qlik Talend Cloud vs SSIS

Oracle Data Integrator (ODI) vs SSIS

Fivetran vs SSIS

Oracle GoldenGate vs SSIS

IBM InfoSphere DataStage vs SSIS

SnapLogic vs SSIS

SAP Data Services vs SSIS

Qlik Replicate vs SSIS

See all alternatives

Related questions

94

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

82

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

75

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

84

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

37

What is the biggest difference between SSIS and Pentaho?

50

What are the pros and cons of SSIS?

48

Which is better - SSIS or Informatica PowerCenter?

51

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

75

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

380

What are the best on-prem ETL tools?