SSIS Reviews

Users commonly praise the ease of use and flexibility of SSIS. Many users appreciate the ability to easily design and execute ETL processes with its intuitive interface. Another valuable feature is the robust set of data transformation tools that allow for complex data manipulation. 

Additionally, users often highlight the scheduling capabilities of SSIS, which enable them to automate tasks and streamline their workflow. The extensive connectivity options of SSIS to various data sources and destinations are frequently mentioned as a key aspect of its value.

• "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."
• "The most valuable feature of the solution is performance."

Some users have commented on the need for better error-handling capabilities, including more descriptive error messages and easier troubleshooting options. Others have pointed out the need for increased flexibility in terms of data transformations, with requests for a wider range of functions and more intuitive tools for complex transformations. 

In addition, users have mentioned the need for improved performance optimization, with suggestions for better memory management and faster processing speeds. Some users have highlighted the need for improved documentation and training resources to help users make better use of the software's features and capabilities.

• "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."
• "Integration and the user interface are areas with certain shortcomings that require some improvements."