SSIS Reviews

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

Vendor: Microsoft

3.8 out of 5

73 reviews
79% willing to recommend

4,867 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 #4 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 67% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 18% of all views.

Helped 839,422 peers since 2012

Featured SSIS reviews

Sakiru Dosumu

Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

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

Read full review

BobAmy

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

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. For flexibility and to make reading the logs in case of errors, I prefer not to put multiple copy operations in the same dataflow, although that is possible. I try to keep in mind how to make production operations as easy as possible in case of failures. I want to give the night crew the best opportunity for success when an error does occur. We have about one error per 400 processes. About 3/4 of these were transitory issues with issues like slow connections and temporary outages. By making the code rerunnable, we can auto-restart on any error, and that resolves 3/4 without human intervention. This leaves any failure after two retries the only issue that the night crew has to do Root Cause Analysis (RCA) on.

Read full review

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

SSIS mindshare

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

Data Integration

PeerAnalyst reports based on SSIS reviews

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

Title	Rating	Mindshare	Recommending
Informatica Intelligent Data Management Cloud (IDMC)	3.9	4.8%	93%	182 interviews Add to research
Azure Data Factory	4.0	10.0%	92%	90 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.

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

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.

"SSIS has a difficult learning curve when dealing with complex transformations."
"SSIS is not stable."
"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."

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

18%

Computer Software Company

12%

Government

Healthcare Company

Manufacturing Company

Insurance Company

University

Educational Organization

Real Estate/Law Firm

Construction Company

Retailer

Energy/Utilities Company

Comms Service Provider

Non Profit

Hospitality Company

Media Company

Legal Firm

Wholesaler/Distributor

Logistics Company

Performing Arts

Consumer Goods Company

Outsourcing Company

Transportation Company

Recreational Facilities/Services Company

Pharma/Biotech Company

Engineering Company

Wellness & Fitness 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