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

SSIS vs Tray.ai comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
6.5
SSIS is cost-effective, enhancing data management efficiency and integration with SQL Server, providing significant operational and financial benefits.
Sentiment score
5.8
Tray.ai automates tasks, significantly reducing workload and engineering demands, with users showing ongoing value appreciation over 19 months.
The tool has made us tremendously more efficient and saved us a significant amount of money.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
Managing Partner at Dynamis Informatica
I have seen a return on investment as the company has been renewing the product for the entire 19 months we have been using it, which indicates that trust is high and they likely see value and advantage in using the system.
Principal AI and Data Science Engineer at a manufacturing company with 10,001+ employees
It has even eliminated a position on our team because that person was no longer needed once we started the automations.
Applications Analyst at a healthcare company with 1,001-5,000 employees
The ROI is clear, as it eliminates hundreds of engineer hours required to build and maintain custom integration connectors, while empowering client partners to manage complex data ingest self-sufficiently.
Dev Ops Engineer at a outsourcing company with 201-500 employees
 

Customer Service

Sentiment score
6.0
Users find Microsoft support adequate for critical issues but often use online resources and community support for minor ones.
Sentiment score
4.3
Tray.ai's support is adequate, with ease of use reducing direct contact, complemented by positive feedback on newsletters and updates.
The first line of support needs to be more knowledgeable.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
I have never used the customer support for Tray.io because the software is very easy to use and we never needed to contact support.
Principal AI and Data Science Engineer at a manufacturing company with 10,001+ employees
 

Scalability Issues

Sentiment score
6.7
SSIS is effective for small to medium enterprises but may face challenges with scalability and performance for large datasets.
Sentiment score
7.3
Tray.io excels in scaling and data management, though complexity arises as operations expand beyond small-scale uses.
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
Tech Lead at a consultancy with 11-50 employees
We were able to deploy it from a small company within Tata with 200 people to what is now a multinational company with 92,000 people globally.
Principal AI and Data Science Engineer at a manufacturing company with 10,001+ employees
Our company uses it for handling high-volume data ingestion and integration orchestration between our platform and external ad services.
Dev Ops Engineer at a outsourcing company with 201-500 employees
The benefits of it being no-code or low-code started to pale in comparison to the cost of making everything slightly more complicated.
Operations Analyst at a tech vendor with 51-200 employees
 

Stability Issues

Sentiment score
7.4
SSIS is highly rated for stability and performance, though minor issues and cloud discrepancies are occasionally noted by users.
Sentiment score
7.9
Tray.ai is stable and efficient but requires setup learning; memory can impact workflows if not managed properly.
It processes large volumes of data quickly.
Managing Partner at Dynamis Informatica
In my experience, Tray.io is stable, as we have never experienced issues with it failing or being unavailable.
Principal AI and Data Science Engineer at a manufacturing company with 10,001+ employees
The biggest issue we have with Tray.io is that it runs out of memory space and does not process all of our workflows.
Applications Analyst at a healthcare company with 1,001-5,000 employees
Tray.io is highly stable for daily scheduled production runs and event-driven webhooks, provided proper error handling, timeout management, and payload validation are built into the workflow steps.
Dev Ops Engineer at a outsourcing company with 201-500 employees
 

Room For Improvement

SSIS needs enhanced error logging, diverse data integration, user management, ease of use, scalability, and better documentation support.
Tray.ai struggles with user accessibility, documentation, and pricing, limiting usability for non-technical teams and smaller organizations.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
Managing Director at Knights Innovation Support Centre
SSIS has a difficult learning curve when dealing with complex transformations.
Managing Partner at Dynamis Informatica
The logging capabilities could be improved, particularly for error logging.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
When an automation fails, it usually provides the JSON format, and if Tray.io could include a summary of what the actual error entails, that would be quite beneficial.
IT Engineer at a consumer goods company with 51-200 employees
I believe Tray.io can be improved by offering integration with Tableau, which is still not available.
Principal AI and Data Science Engineer at a manufacturing company with 10,001+ employees
There is a steep learning curve in user accessibility; the builder is highly developer-centric, making it difficult for a non-technical team member to modify or troubleshoot workflows.
Automation Engineer at a educational organization with 11-50 employees
 

Setup Cost

SSIS is economical with SQL Server licenses, offering favorable pricing and integration, though add-ons may increase costs.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
Managing Partner at Dynamis Informatica
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
However, it could be a bit cheaper.
Tech Lead at a consultancy with 11-50 employees
No one has complained in the finance department, and it is very rare for Tata Motors to refrain from complaining about pricing.
Principal AI and Data Science Engineer at a manufacturing company with 10,001+ employees
 

Valuable Features

SSIS offers efficient, scalable ETL with seamless Microsoft integration, user-friendly interface, flexibility, and cost-effectiveness, enhancing data processes.
Tray.io offers low-code automation with robust integrations, intuitive design, and advanced features to enhance workflow resilience and efficiency.
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
Managing Partner at Dynamis Informatica
SSAS is included in the base installation of SQL Server.
Managing Director at Knights Innovation Support Centre
The connector SDK is also very nice; it has a large library of pre-built connectors that can connect a lot of proprietary internal tools directly into Tray.io, allowing the developer to build, test, and deploy custom connectors using Node.js and integrate the data directly into Tray.io.
Automation Engineer at a educational organization with 11-50 employees
The best features Tray.io offers include the visual workflow builder and HTTP client blocks that enable rapid prototyping and deployment of complex API interactions, including raw HTTP requests, data mappers, and dynamic token generation.
Dev Ops Engineer at a outsourcing company with 201-500 employees
The logging and debugging features in Tray.io have helped us considerably, especially when dealing with APIs that return errors sometimes.
Operations Analyst at a tech vendor with 51-200 employees
 

Categories and Ranking

SSIS
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
76
Ranking in other categories
Data Integration (2nd)
Tray.ai
Average Rating
7.2
Reviews Sentiment
5.4
Number of Reviews
7
Ranking in other categories
Process Automation (17th), Cloud Data Integration (18th), Low-Code Development Platforms (20th), Integration Platform as a Service (iPaaS) (14th)
 

Featured Reviews

reviewer2318280 - PeerSpot reviewer
Tech Lead at a consultancy with 11-50 employees
Reporting has become streamlined for year-end data checks but integration still needs improvement
When I talk about SQL Server, I am working with SSIS, the data integration tool. I am not entirely sure if I use SSIS as a library of transformations or if I personally work with an extensive library of transformations. I have integrated SSIS with SQL Server Management Studio, and I am very satisfied with the integration as it is integrated well. I am not using the debugging feature in SSIS because the developers would be the ones that would actually utilize it. I have noticed that in 2022, AI functionality has actually been implemented already. I would rate this review overall at a 7.
Amrit Dash - PeerSpot reviewer
Automation Engineer at a educational organization with 11-50 employees
Automated student enrollments have reduced manual work and now free our team for higher-value support
Tray.io is definitely a highly powerful tool, but there are three main areas that I feel could be improved. There is a steep learning curve in user accessibility; the builder is highly developer-centric, making it difficult for a non-technical team member to modify or troubleshoot workflows. Introducing a more intuitive visual interface similar to what we have in make.com right now would make the platform much more collaborative and easier to work with for any non-technical folks or newly onboarded engineers, allowing them to be briefed faster. Visual debugging is another area where troubleshooting complex nested loops can feel very abstract. Having clearer, more visual step-by-step data tracking during test runs would speed up the development and testing process. The pricing model is geared heavily towards enterprise budgets; offering more flexible mid-market pricing tiers would make it more accessible for a growing organization that wants a small start and scale up gradually. The core platform security is highly robust and easily meets our requirements for SOC 2 and GDPR compliance. However, when utilizing their AI features such as Merlin AI with sensitive student data, we maintain a very cautious approach. While Tray.io provides enterprise-grade governance guardrails and data masking capabilities, our internal compliance policies prevent us from passing any personally identifiable student information directly through AI-driven processors. We trust Tray.io's underlying infrastructure security, but we believe organizations must still enforce strict data filtering protocols on their end to ensure student privacy is maintained. During our evaluation, we tested the AI capabilities in a sandbox environment, primarily using it to generate workflow drafts and natural language prompts from web data schemas. Strength-wise, it is highly capable when it comes to translating simple text descriptions into functional workflow templates. It serves as a great accelerator, helping to map standard files quickly and reducing the initial setup time for basic integrations. For issues, in the case of highly custom APIs or deeply nested data structures, accuracy declines. We noticed occasional misinterpretation of complex schemas, meaning our developers still had to manually review and correct the outputs. It is a highly helpful productivity booster but still requires human oversight for enterprise-grade reliability.
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
921,523 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
13%
Manufacturing Company
8%
Outsourcing Company
8%
Construction Company
8%
Comms Service Provider
14%
Construction Company
11%
Outsourcing Company
11%
Healthcare Company
10%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise19
Large Enterprise58
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise1
Large Enterprise4
 

Questions from the Community

Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What is your experience regarding pricing and costs for SSIS?
Pricing is pretty reasonable, so I would rate it at a 5. However, it could be a bit cheaper.
What needs improvement with SSIS?
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly. The initial setup for SSIS is somewhat complex in the beginning, but once you und...
What needs improvement with Tray.io?
Native rate limit and auto-retry handling can be improved, as when hitting 429 errors or too many requests errors during high-volume API loops, Tray.io lacks native configured backoff and retry log...
What is your primary use case for Tray.io?
Tray.io serves as the core iPaaS orchestration and data ingestion engine between our primary system and numerous external platforms such as ad servers like GAM, FreeWheel, Flitepath, Facebook, ERPs...
What advice do you have for others considering Tray.io?
My advice for others looking into using Tray.io is to modularize earlier. I recommend not building massive monolithic workflows, but rather creating single-purpose callable workflows and triggering...
 

Comparisons

 

Also Known As

SQL Server Integration Services
No data available
 

Overview

 

Sample 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
Copper, DigitalOcean, Udemy, AdRoll, FICO, Outreach
Find out what your peers are saying about SSIS vs. Tray.ai and other solutions. Updated: November 2026.
921,523 professionals have used our research since 2012.