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

SSIS Reviews

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

What is SSIS?

Get the report
Helped 830,574 peers since 2012

Featured reviews

SSIS mindshare

As of January 2025, the mindshare of SSIS in the Data Integration category stands at 8.9%, down from 9.5% compared to the previous year, according to calculations based on PeerSpot user engagement data.
Data Integration

PeerAnalyst reports

TypeTitleDate
CategoryData IntegrationJan 12, 2025Download
ProductReviews, tips, and advice from real usersJan 12, 2025Download
ComparisonSSIS vs Azure Data FactoryJan 12, 2025Download
ComparisonSSIS vs Informatica PowerCenterJan 12, 2025Download
ComparisonSSIS vs Informatica Intelligent Data Management Cloud (IDMC)Jan 12, 2025Download
Suggested products
TitleRatingMindshareRecommending
Informatica Intelligent Data Management Cloud (IDMC)4.0N/A93%181 interviewsAdd to research
Azure Data Factory4.010.8%92%88 interviewsAdd to research
 
 
Key learnings from peers

Valuable Features

Room for Improvement

ROI

Pricing

Popular Use Cases

Service and Support

Scalability

Stability

Review data by company size

By reviewers
By visitors reading reviews

Top industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
12%
Government
8%
Manufacturing Company
6%
Healthcare Company
6%
Insurance Company
6%
University
5%
Educational Organization
4%
Construction Company
4%
Retailer
3%
Energy/Utilities Company
3%
Real Estate/Law Firm
3%
Comms Service Provider
2%
Media Company
2%
Non Profit
2%
Legal Firm
2%
Hospitality Company
2%
Wholesaler/Distributor
1%
Logistics Company
1%
Performing Arts
1%
Transportation Company
1%
Consumer Goods Company
1%
Outsourcing Company
1%
Recreational Facilities/Services Company
1%
Pharma/Biotech Company
1%
Wellness & Fitness Company
1%
Engineering Company
1%

Compare SSIS with alternative products

Learn more about SSIS

Product Video

SSIS video

SSIS customers

Related questions

 

SSIS reviews

Sort by:
BobAmy - PeerSpot user
Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.
Verified user of SSIS
Aug 21, 2023
Robust and does a good job of handling overload conditions

Pros

"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."

Cons

"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."
CP
Senior Systems Analyst at Optum
Verified user of SSIS
Aug 5, 2024
Helps to move data from one server to another and translate it in the middle

Pros

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature. "

Cons

"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections. "
Find out what your peers are saying about SSIS. Updated December 2024
830,574 professionals have used our research since 2012.
Sakiru Dosumu - PeerSpot user
Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.
Verified user of SSIS
Mar 26, 2024
Its ability to transform and transport data is extremely valuable

Pros

"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."

Cons

"Improvement as per customer requirements. "
Shubham-Agarwal - PeerSpot user
Manager - Projects at Cognizant
Verified user of SSIS
Mar 30, 2023
Maintaining the solution and contacting its support team is easy

Pros

"We can connect with multiple data sources easily using an external connector in SSIS."

Cons

"We have issues with SSIS connectors while extracting data from Excel sources. "
CEMREKASSARA - PeerSpot user
Data Scientist/BI Developer at QNB Invest
Verified user of SSIS
Nov 26, 2024
Good for data loading ETL processes but needs reliability improvements

Pros

"The setup is easy to use and understand."

Cons

"SSIS is not stable."
Arpita-Mishra - PeerSpot user
Specialist Software Engineer at a financial services firm with 10,001+ employees
Verified user of SSIS
Jan 24, 2023
Easy to set up and works with smaller datasets but is not user-friendly

Pros

"It is easy to set up the solution. "

Cons

"It hangs a lot of the time. "
Rohit Rastogi - PeerSpot user
Lead Data Engineer at Capgemini
Verified user of SSIS
Dec 3, 2022
Great features, easy to set up, and makes creating packages easy

Pros

"It is easy to set up the product."

Cons

"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
LD
Information Technology Division Director at Ethiopian Roads Administration
Verified user of SSIS
Aug 1, 2024
Offers data warehousing capabilities but needs to improve the integration features

Pros

"The most valuable feature of the solution is performance. "

Cons

"Integration and the user interface are areas with certain shortcomings that require some improvements."