SSIS Reviews

Name: SSIS
Brand: Microsoft
Rating: 3.8 (74 reviews)

Vendor: Microsoft

3.8 out of 5

74 reviews
79% willing to recommend

4,080 followers

Start review

What is SSIS?

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Get the SSIS Buyer's Guide and find out what your peers are saying about SSIS, Informatica Intelligent Data Management Cloud (IDMC), Azure Data Factory and more!

SSIS is the #3 ranked solution in top Data Integration Tools. PeerSpot users give SSIS an average rating of 7.6 out of 10. SSIS is most commonly compared to Informatica Intelligent Data Management Cloud (IDMC): SSIS vs Informatica Intelligent Data Management Cloud (IDMC). SSIS is popular among the large enterprise segment, accounting for 66% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 19% of all views.

Helped 854,338 peers since 2012

Featured SSIS reviews

Albert Lacerda

Managing Partner at Dynamis Informatica

One of the best aspects of SSIS ( /products/ssis-reviews ) is that it is built into Microsoft SQL Server ( /products/sql-server-reviews ), so there are no additional costs involved. Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent. I can process 1.2 million lines of data in a few minutes, even when running over a VPN connection.

Read full review

Sean Achim

Managing Director at Knights Innovation Support Centre

Stability is rated at 10. One other important aspect I appreciate is that SSAS is included in the base installation of SQL Server. Obviously, it requires installation, but it is readily available, which is a major strength. It's all about setting it up, configuring it, and then using it. If there are additional costs associated with it or separating it as a second product, that would be a disadvantage. The area of improvement is really in education. Microsoft is trying to push everything as a Power BI solution or trying to get people to solve the problems which are solved with SSAS in another space in Power BI, or in Power Pivot, is not enough. There's not enough marketing, conversation, and support around that space. As a result, we end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model. That leads people to consider alternate solutions because SAP and others argue that their whole thing is in memory, and they disseminate misleading information. Additionally, what would be very helpful is local user group developments, so getting people around the table and teaching them how to use it. That is the biggest problem; it's not the technology itself. The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.

Read full review

CEMREKASSARA

Data Scientist/BI Developer at QNB Invest

I use SSIS for data loading ETL processes. I am responsible for the EDW layer and get new data from other data sources into the EDW via SSIS SSIS has too many bugs. Sometimes it works, sometimes it doesn't. I try to use a package, and it won't work on my computer, but it will on another user's…

Read full review

SSIS mindshare

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

Data Integration

PeerResearch reports based on SSIS reviews

Type	Title	Date
Category	Data Integration	Jun 4, 2025	Download
Product	Reviews, tips, and advice from real users	Jun 4, 2025	Download
Comparison	SSIS vs Azure Data Factory	Jun 4, 2025	Download
Comparison	SSIS vs Informatica Intelligent Data Management Cloud (IDMC)	Jun 4, 2025	Download
Comparison	SSIS vs Informatica PowerCenter	Jun 4, 2025	Download

Title	Rating	Mindshare	Recommending
Informatica Intelligent Data Management Cloud (IDMC)	4.0	4.3%	93%	185 interviews Add to research
Azure Data Factory	4.0	8.4%	92%	91 interviews Add to research

Valuable Features

SSIS excels in ease of use, data integration from diverse sources, and rapid deployment. Users appreciate its low learning curve, scalability, and drag-and-drop interface. It integrates seamlessly with Microsoft tools, offers high customization via scripting, and supports parallel processing. SSIS provides robust functionality like data flows, bulk imports, error handling, and cloud deployment. Its affordability compared to competitors and compatibility with SQL server enhance its utility for many users.

"Stability is rated at 10."
"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."
"The setup is easy to use and understand."

Room for Improvement

SSIS faces several challenges, such as limited built-in user account functionality, subpar error logging, and lack of native version control. Its GUI and interface could benefit from increased responsiveness and less complexity. There are issues with slow performance when dealing with high data volumes and difficulty integrating with diverse data sources like Oracle and Salesforce. Scalability, real-time processing capability, and metadata management also need enhancement, along with improved documentation and ease of use for non-expert users.

"There's no support for it at all. If you haven't undergone the qualifications, you wouldn't even know you should phone someone."
"SSIS has a difficult learning curve when dealing with complex transformations."
"SSIS is not stable."

ROI

SSIS is considered a reasonable investment given its cost, though higher budgets might lead some to opt for alternative tools. Users have noted a positive return from implementing SSIS. It presents cost-effectiveness since there are no extra charges beyond the SQL Server license. Furthermore, SSIS greatly improves data management efficiency, reinforcing its financial benefits.

Pricing

SSIS pricing is generally favorable for enterprise buyers, especially when bundled with SQL Server licenses, often at no additional cost. Many users appreciate the integration with Microsoft technologies, noting SSIS as a cost-effective option compared to rivals like Oracle or Talend. Though some find the licensing slightly high, the value for money is commendable. The solution typically requires an SQL Server license, with some users highlighting the potential for additional costs with specific configurations or add-ons.

"The solution comes free of cost."
"People have to opt for a perpetual-based licensing model."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

Popular Use Cases

SSIS is primarily used for ETL processes, data movement, and integration between various systems. Users leverage it for building data warehouses, creating BI reports, and transforming large volumes of data seamlessly. It's widely adopted for on-premise deployments, where it facilitates data extraction from diverse sources like SQL Server and Oracle. Additionally, SSIS supports creating data flows, importing/exporting data, and handling tasks in specific workflows for effective data management.

Service and Support

Users have mixed feelings about SSIS's customer service and support. Many handle issues independently, using online resources and community forums. Microsoft technical support is appreciated for dire situations, although response times vary and obtaining assistance can be challenging. Some report difficulties with finding quick help for non-critical matters. Microsoft's support quality has declined for on-premise solutions, but online documentation and user communities often provide the needed assistance.

Deployment

Most find SSIS's initial setup easy and straightforward, often requiring minimal time and resources. Experienced teams handle deployment swiftly, but some mention challenges with complex configurations or large data volumes. Installation may include additional steps such as Visual Studio tweaks. Typically, a small team suffices for deployment, with support available from online resources, making it accessible for technical teams.

Scalability

SSIS generally scales well, yet experiences vary based on data volume and infrastructure. Many report satisfactory scaling, particularly with efficient SQL Server use. Larger data demands may reveal limits, although it meets needs for small to medium sizes. Some indicate cost challenges on cloud platforms, while others adapt it for diverse operations. Performance varies, with mixed opinions about handling massive data, but SSIS provides robust features for both small and enterprise use cases.

Stability

SSIS shows strong stability, with most users not experiencing significant issues. Many find it dependable with no crashes or freezes. However, some face performance challenges, particularly with extensive ETL processing or local system hosting. It remains mature and reliable for many, although occasional bugs and UI problems exist. Effective infrastructure can enhance performance. Its stability often receives high ratings, with users finding it reliable and easy to maintain in production environments.

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our SSIS Buyer's Guide for additional reliable information.

Review data by company size

By reviewers

By visitors reading reviews

Top industries

By visitors reading reviews

Financial Services Firm

19%

Computer Software Company

12%

Government

Manufacturing Company

Insurance Company

Healthcare Company

University

Educational Organization

Real Estate/Law Firm

Construction Company

Retailer

Comms Service Provider

Energy/Utilities Company

Non Profit

Hospitality Company

Legal Firm

Performing Arts

Wholesaler/Distributor

Media Company

Logistics Company

Consumer Goods Company

Outsourcing Company

Recreational Facilities/Services Company

Transportation Company

Pharma/Biotech Company

Engineering Company

Compare SSIS with alternative products

Learn more about SSIS

SSIS was previously known as SQL Server Integration Services.

SSIS customers

1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo