# Universal SSIS Components by Devart Reviews **Vendor:** Devart **Category:** [On-Premise Data Integration Software](https://www.g2.com/categories/on-premise-data-integration) **Average Rating:** 4.5/5.0 **Total Reviews:** 22 ## About Universal SSIS Components by Devart Get 95% off the SSIS Universal Bundle to boost your workflows! With one toolset, you can improve productivity, level up data consolidation, and simplify integration. - All essential tools for data integration in one bundle - Enhanced data workflow with advanced features and functionality - Trusted and efficient tools to ensure complete control over data - Exceptional value at a reduced cost ## Universal SSIS Components by Devart Pros & Cons **What users like:** - Drag (1 reviews) - Ease of Use (1 reviews) - Easy Integrations (1 reviews) - Integrations (1 reviews) - Versatility (1 reviews) ## Universal SSIS Components by Devart Reviews ### 1. Easy-to-Use Drag-and-Drop ETL with Powerful Data Integration **Rating:** 4.5/5.0 stars **Reviewed by:** Yashendra S. | Associate, Small-Business (50 or fewer emp.) **Reviewed Date:** April 07, 2026 **What do you like best about Universal SSIS Components by Devart?** What I like most is how easy it is to use while still offering powerful data integration capabilities. The drag-and-drop interface makes it straightforward to design ETL workflows without a lot of coding, which ends up saving significant development time. **What do you dislike about Universal SSIS Components by Devart?** One downside is the steep learning curve, especially for beginners, due to the wide range of features and configurations. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** Universal SSIS Components by Devart address the challenge of complex data integration across multiple systems by enabling seamless connections between databases, cloud apps, and various file formats within a single ETL workflow ### 2. Integration at fingertips **Rating:** 3.5/5.0 stars **Reviewed by:** Vasu G. | Digital Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** February 10, 2024 **What do you like best about Universal SSIS Components by Devart?** It intergrates most of my work into a single data flow component. **What do you dislike about Universal SSIS Components by Devart?** Not easy to find online support and online community **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** Cloud database. ### 3. Evaluation of SSIS Data Flow Components: Navigating Challenges in Ease of Use, Integrations. **Rating:** 4.5/5.0 stars **Reviewed by:** Garlapati A. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** January 18, 2024 **What do you like best about Universal SSIS Components by Devart?** SSIS indulges a optical design interface that enhances the formation of data flow tasks. Users can develop ETL workflows by utilising just a draga nd drop approach which is very ease for implementation. This is frequently used for reccuring the ETL Tasks that leverages the servers on Microsoft. It also offers rich set of features that contains many data transformations, various workflow elements. This also integrates seamlessly with other Microsoft SQL Server components. Customer support for this SSIS will be provided on user's support agreement with the microsoft. Its frequency of use depends on the data integration requirements within in the environement. **What do you dislike about Universal SSIS Components by Devart?** Users, mainly beginners, may find learning curve steep due to extensive features and configurations available in SSIS. Debugging complex SSIS Packages can be challenging. The Frequency of Use might depend on organization specific ETL Requirements. Level and quality of customer support may vary based on user's support agreement with microsoft. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** Problem was like managing the data from diverse sources with different formats and structures and the benifit is like it simplifies integration of data from various sources, allowing seamless connectivity and transformation for unified view of data. **Official Response from Jordan Sanders:** > We appreciate you taking the time to let us know about your experience! We are always looking for ways to improve. ### 4. SSIS data flow components demystified **Rating:** 4.0/5.0 stars **Reviewed by:** Sumeet J. | Lead Assistant Vice President, Enterprise (> 1000 emp.) **Reviewed Date:** January 06, 2024 **What do you like best about Universal SSIS Components by Devart?** The ability to handle large volumes of data efficiently. SSIS provides a wide range of source , transformation and destination components. Also, it has robust error handling capabilities And its ability to integrate with other Microsoft technologies like SQL server databases, Azure services and more. **What do you dislike about Universal SSIS Components by Devart?** It has limited cross platform support - SSIS is primarily designed for integration with Microsoft technologies and its native components might not be as well suited for cross platform integration with non Microsoft systems Also, debugging SSIS packages can be complex, especially when dealing with intricate data flow logic or when errors occur in larger packages. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** SSIS provides a robust platform for designing and executing ETL processes, facilitating seamless integration and transformation of data from various sources SSIS automates ETL processes, reducing manual intervention, minimizing errors and improving efficiency in data integration tasks **Official Response from Jordan Sanders:** > Thank you for sharing your experience with us. Your feedback helps us to improve service for everyone. ### 5. Unlocking seamless data flows **Rating:** 5.0/5.0 stars **Reviewed by:** Praveen K. | Power BI Developer, Enterprise (> 1000 emp.) **Reviewed Date:** February 01, 2024 **What do you like best about Universal SSIS Components by Devart?** * Convenient for users as it is a Microsoft Product * Offers an extensive set transformations designed to handle tasks related to manipulating and processing data. * Drag and Drop featurer makes the work easy * Strong community and support on time. **What do you dislike about Universal SSIS Components by Devart?** * Moving SSIS packages from one version to another is more challenging and requires extra time and efforts. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** * Can collect and handle data from variety of sources * Best ETL process tool * Allows scripting using languages like C# **Official Response from Jordan Sanders:** > Thank you so much for your feedback! We do really appreciate it. ### 6. SQL server integration Service **Rating:** 4.0/5.0 stars **Reviewed by:** MANISH P. | Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** January 22, 2024 **What do you like best about Universal SSIS Components by Devart?** i like ssis data components beacause yhey easy to usedfor versatility . They act like building blocks that help me design data flows seamlessly.Dragging and droping facilty,easy to integrate.performace good **What do you dislike about Universal SSIS Components by Devart?** In my opinion, one drawback of SSIS Data Flow Components is the learning curve, especially for beginners and roubleshooting a bit frustrating they should focus on customer suppoert **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** there are some problems that i face are 1)data interation and 2)error handling so SSIS helps me solve it **Official Response from Jordan Sanders:** > Thanks a lot. Your feedback is valuable to us. ### 7. Automation in ssis is quite easy to use and understand **Rating:** 4.5/5.0 stars **Reviewed by:** Aditya K. | Technical Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** February 05, 2024 **What do you like best about Universal SSIS Components by Devart?** Ease of using it, easy to implement and features **What do you dislike about Universal SSIS Components by Devart?** It's rare but sometime it crashes and doesn't open packages **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** Automation of the work,workflow understanding, DB update and file upload. **Official Response from Jordan Sanders:** > Thanks a lot. Your feedback is valuable to us. ### 8. Evaluating SSIS Data Flow **Rating:** 4.0/5.0 stars **Reviewed by:** Lulu B. | Career Coach | Mentor | Interview Preparation Guide, Small-Business (50 or fewer emp.) **Reviewed Date:** February 02, 2024 **What do you like best about Universal SSIS Components by Devart?** It basically provides connection to wide range sources ,transformation and destination component too with a robust error handling capacity . It efficiently handles large volumes of Data ,it seemlessly integrates with Microsoft SQL server,Azure services and many more **What do you dislike about Universal SSIS Components by Devart?** It is not suited with integration with other Non Microsoft systems. This SSIS is basically designed to integrate with Microsoft technologies and its components **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** Data integration **Official Response from Jordan Sanders:** > Thanks a lot. Your feedback helps us to improve service for everyone. ### 9. My experience with G2 SSIS Data Flow Components was fabulous. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** January 11, 2024 **What do you like best about Universal SSIS Components by Devart?** Most helpful thing about SSIS Data Flow Components is that it streamlines data extraction, transformation, and loading processes. It is very easy to use. **What do you dislike about Universal SSIS Components by Devart?** There are not many things that can be considered as downsides of SSIS Data Flow Components. Yet, to name one, Limited usability for non-developers can be a downside. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** SSIS helps is solving business problems like copying data from source to destination. Redirecting error output helps to keep the data transfer running even if an inconsistent or invalid record is received. Storing the error output to another storage such as table or file can helps to investigate it later. **Official Response from Jordan Sanders:** > Thank you for your feedback. We really appreciate it! ### 10. Easy to use **Rating:** 5.0/5.0 stars **Reviewed by:** Raghvendra K. | Data Developer, Enterprise (> 1000 emp.) **Reviewed Date:** February 04, 2024 **What do you like best about Universal SSIS Components by Devart?** Ssis is very useful in data migration tasks we can use it while send data to pn prem. We use it as middle ware for the task. **What do you dislike about Universal SSIS Components by Devart?** All components are good as of now. But response time is slightly slow **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** Sometimes it slow depending on data size **Official Response from Jordan Sanders:** > Thank you for your feedback. We really appreciate it! ### 11. What and how we are using SSIS Data Flow Components **Rating:** 4.0/5.0 stars **Reviewed by:** OM P. | Software Engineer 1, Mid-Market (51-1000 emp.) **Reviewed Date:** January 16, 2024 **What do you like best about Universal SSIS Components by Devart?** We can get the data from source or at any other location fast. Function and support is good. documentation is there . **What do you dislike about Universal SSIS Components by Devart?** They are not updating with time and some of thing are to navie. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** Connecting and trnsformation of data **Official Response from Jordan Sanders:** > Thanks a lot. Your feedback is valuable to us. ### 12. My review **Rating:** 4.5/5.0 stars **Reviewed by:** Yash J. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** January 18, 2024 **What do you like best about Universal SSIS Components by Devart?** The architecture of it, ease of use, satisfaction **What do you dislike about Universal SSIS Components by Devart?** ease of use, ease of implementation, customer support, frequency of use **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** Managing data structures, managing cloud platform **Official Response from Jordan Sanders:** > Thank you for your feedback. ### 13. very useful to performing and scheduling integration tasks **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Construction | Mid-Market (51-1000 emp.) **Reviewed Date:** December 19, 2023 **What do you like best about Universal SSIS Components by Devart?** the most i like is execute process task which can run command prompt commands **What do you dislike about Universal SSIS Components by Devart?** new connectors and being microsoft specifc. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** API Integration via third party softwares like zappysys ftp and sftp integration data integration **Official Response from Jordan Sanders:** > Thank you so much for your feedback! ### 14. Awesome Experience **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Consulting | Small-Business (50 or fewer emp.) **Reviewed Date:** January 31, 2024 **What do you like best about Universal SSIS Components by Devart?** I love their flexibility in designing and managing ETL processes. **What do you dislike about Universal SSIS Components by Devart?** The learning curve was a bit steep and also sometimes I struggled with using them in intricate data integration scenarios. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** Can't disclose everything but it made the designing of a custom etl pipeline of my company secure and easy. **Official Response from Jordan Sanders:** > Thank you for your feedback. We are always looking for ways to improve. ### 15. It was really a great experience by using Data flow components to data transfer **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** January 12, 2024 **What do you like best about Universal SSIS Components by Devart?** The best part in data flow components that we have different different templates to use and Crete data pipeline **What do you dislike about Universal SSIS Components by Devart?** There is not much more to dislike about this but it's little bit costly to use . **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** We use this to creating the data pipeline and automated the data line from on prem to gcp **Official Response from Jordan Sanders:** > We are so grateful for your review. ### 16. Microsoft's own ETL suite that gets you data to and from SQL Server **Rating:** 4.0/5.0 stars **Reviewed by:** Jonathan H. | Marketing Lead Data Officer, Enterprise (> 1000 emp.) **Reviewed Date:** November 03, 2021 **What do you like best about Universal SSIS Components by Devart?** This uses the popular Visual Studio app to build your own structure to push data into the server. For the most part, I'm not writing code but joining up boxes to produce a workflow of one type of data, any necessary changes, to the final target source of data. **What do you dislike about Universal SSIS Components by Devart?** - Its fiddly to set up. I now realise you have to install SQL Server Data Tools, which is a plug-in on top of Visual Studio. As my work PC which connects to an Azure VM, I have built a lab to try it at home on my own PC. - I seem to have two versions of VS installed, and it only works on 2017 not 2019. Sometimes when opening my packages, side menus are missing, looking through drop-down menus doesn't show the correct ones. Instead opening the .SLN fie from the desktop then means it works all ok. The Error box at the bottom sometimes is missing, and sometimes my scripts don't work, and there is less detailed information which can be hard to pinpoint what's wrong. - I'm trying to build a workflow of data that I want my non-technical colleagues to run when I am not there, so still getting the hang of it. For the most part, it's great, still a lot to learn. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** My current processes are editing very complex XLS spreadsheets to build datasets of clients to send to a bulk mailer web app. By doing this with SSIS I can automate this and make a task that takes hours and is very error-prone run instantly. **Official Response from Jordan Sanders:** > Thank you for sharing your experience with us. Your feedback helps us to improve service for everyone. ### 17. Have 10 years of experience **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 13, 2019 **What do you like best about Universal SSIS Components by Devart?** The data flow components is easy to use, it is an drag and drop tool which has so many features and in house tools which makes a developer job quite easy and productive **What do you dislike about Universal SSIS Components by Devart?** Complex transformations and some tools like sort, merge etc hinders performance which is a drawback. So typically we call a stored procedure as a mitigation **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** Moving data from point a to point b is very fast, it is an in-house tool of Microsoft which works very well with sql server **Official Response from Jordan Sanders:** > Thanks a lot. Your feedback is valuable to us. ### 18. I have three year experience to use SSIS data flow components **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Services | Mid-Market (51-1000 emp.) **Reviewed Date:** February 01, 2019 **What do you like best about Universal SSIS Components by Devart?** 1) The drag and drop feature of SSIS is easy and intuitive for the desired functionality. 2) The templates like SCD are easy to configure and use to do a lot of heavy work. 3) The runtime debugging is a great feature and helps to find issues in complex scenario. 4) the event handler feature is of great use. User can raise custom events for a specific action. 5) It also provide data transformations. These transformations help to change data as per requirement. **What do you dislike about Universal SSIS Components by Devart?** 1) SSIS do not provide performance optimisation tools. Most of activities took place behind the scenes. So, user is required to do some heavy work to do fix performance issues. 2) SSIS do not provide debugging at its core level. Like user can see the results of a procedure at runtime. But, it do not show internal debugging of stored procedure. 3) SSIS do not provide enough templates. I think SSIS should provide basic template with multiple components and user should be able to configure them as per available/required resources. **Recommendations to others considering Universal SSIS Components by Devart:** It's a great tool to collect data from variety of sources. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** 1) It helps to collect data from variety of sources. Like, Excel,SQL,csv,XML etc. 2) it's easy to use this. User can perform some complex task with drag and drop. 3) it's easy to customise or modify existing SSIS packages. **Official Response from Jordan Sanders:** > Thank you for letting us know about your experience. We’ll work on improving to meet our customers’ expectations in the future. ### 19. SSIS ETL Services **Rating:** 5.0/5.0 stars **Reviewed by:** Divya A. | Senior software engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** September 25, 2018 **What do you like best about Universal SSIS Components by Devart?** Making connections is easy with SSIS. You can track execution activity by just looking at data flow task progress. When converting source components to destination data types, the SSIS makes it super easy and takes care of metadata issues and synchronization on its own. All in all a very useful product for ETL design. **What do you dislike about Universal SSIS Components by Devart?** The product should have advanced mechanisms of error logging. If the container fails, the only way by which one can tell is by looking at error list output at the end of horizontal menu. The product should have capability of running enterprise level of jobs and monitor all jobs in a single screen just like Control-M. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** ETL designing is super easy with this product. Maintaining historical data is really beneficial to any organization. Deployment and maintenance is not an overhead. **Official Response from Jordan Sanders:** > We appreciate you taking the time to let us know about your experience! We are always looking for ways to improve. ### 20. Benefits for ssis data flow **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 08, 2019 **What do you like best about Universal SSIS Components by Devart?** Ssis is very easy to use. This etl tool can connect to multiple datasources and load data to multiple type of detinations like csv,Excel,database etc **What do you dislike about Universal SSIS Components by Devart?** Some times the ssis gives hang issue due to memory constrainst and we have to restart the solution **Recommendations to others considering Universal SSIS Components by Devart:** Good **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** We are using ssis data flow to load data from Hadoop to SQL database which is then used for dimentional modelling. **Official Response from Jordan Sanders:** > We are so grateful for your review. ### 21. SSSI Data Flow Components **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Education Management | Enterprise (> 1000 emp.) **Reviewed Date:** March 25, 2019 **What do you like best about Universal SSIS Components by Devart?** The components are intuitive and easy to use. **What do you dislike about Universal SSIS Components by Devart?** The IDE crashes on rare on some occasions. **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** We are able to get our SSIS packages developed and deployed in a much more timely manner, **Official Response from Jordan Sanders:** > Thank you so much for your feedback! ### 22. SSIS Data Flow components **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Investment Management | Enterprise (> 1000 emp.) **Reviewed Date:** January 04, 2016 **What do you like best about Universal SSIS Components by Devart?** The ease of moving data from multiple sources to SQL Server given the amount of transformations that are all possible to implement within SSIS **What do you dislike about Universal SSIS Components by Devart?** The clunky feel of the source wizard. I also would like to use something with a little more flexibility when interacting with MS Excel as well as MS Access **What problems is Universal SSIS Components by Devart solving and how is that benefiting you?** The business problems it is solving is moving data into our data warehouse. We exclusively use SSIS and the Data Flow Task to move data from our source systems into our warehouse **Official Response from Jordan Sanders:** > Thanks a lot. Your feedback is valuable to us. ## Universal SSIS Components by Devart Discussions - [What are the different types of data sources available in SSIS?](https://www.g2.com/discussions/what-are-the-different-types-of-data-sources-available-in-ssis) - 1 comment - [What are the 3 data flow components of SSIS?](https://www.g2.com/discussions/what-are-the-3-data-flow-components-of-ssis) - 1 comment - [View Universal SSIS Components by Devart pricing details and edition comparison](https://www.g2.com/products/devart-universal-ssis-components-by-devart/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-11+02%3A06%3A33+-0500&secure%5Bsession_id%5D=f08595a4-4d9d-48a8-a4ae-a995b68017d1&secure%5Btoken%5D=6b7ed28a8dcbab944e9650bf63e5795a1f66b2846a4232328f9db4db7a4737a1&format=llm_user) ## Top Universal SSIS Components by Devart Alternatives - [Pentaho Data Integration](https://www.g2.com/products/pentaho-data-integration/reviews) - 4.3/5.0 (17 reviews) - [Oracle Data Integrator](https://www.g2.com/products/oracle-data-integrator/reviews) - 4.0/5.0 (15 reviews) - [FME Platform](https://www.g2.com/products/fme-platform/reviews) - 4.6/5.0 (125 reviews)