SSIS Reviews

Customers found SSIS to be cost-effective due to the lack of extra fees apart from the SQL Server license. They appreciated its ability to enhance data management efficiency significantly. Although deemed a good choice for limited budgets, some expressed that they would opt for an alternative if funds were higher. Overall, users noted that SSIS delivered a return on investment.

Enterprise buyers evaluating SSIS find its pricing favorable, especially when bundled with SQL Server, offering no additional cost. Comparatively, it proves economical against competitors like Talend and Informatica. Licensing is often included in SQL Server packages, providing value with integrated services like database engine, SSIS, reporting, and analysis services. While some find licensing details complex, many organizations benefit from favorable terms, enhancing affordability and value. Add-ons can increase costs, but overall, the solution is competitively priced.

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

Users primarily utilize SSIS for ETL processes in data integration, warehousing, and migration tasks. They employ it to move and transform data across various environments, including SQL Server, Oracle, and Excel. Many focus on creating data flows, ETL packages, and reports. They're also inclined to use SSIS for building automated data processes and pipelines, often integrating it with tools like Power BI for reporting and visualization tasks.

Many users handle issues independently without contacting customer service. However, some express dissatisfaction with response times, finding more effective support online. Microsoft support is generally considered effective for complex or critical issues, although it can be expensive and challenging to access. Technical support is typically rated well, but many rely on online resources for troubleshooting. Microsoft support quality varies, with some noting a decline over time.

Many users find SSIS's initial setup straightforward and easy, with deployment typically taking a few hours to a day. It often requires minimal technical staff, usually one or two people. Although some find certain aspects like configuring with Visual Studio or managing security can be cumbersome, most emphasize the ease of installation, particularly for those with SQL expertise. Complex scenarios might increase setup difficulty, needing DBA involvement and more time.

SSIS is often appreciated for its scalability, particularly in smaller and medium-sized enterprises. While some express challenges with scaling high data volumes and note potential performance bottlenecks, many users have expanded its use across numerous projects and departments, including significant enterprise applications. SSIS's capacity to handle transformations, integrations, and processes both on-premises and in the cloud contributes to its scalability, supporting diverse user groups and data environments effectively.

Feedback on SSIS highlights its consistent stability. Many mention it runs reliably, with few bugs or glitches, and it rarely crashes or freezes. It handles large data volumes quickly. Though some note minor issues with the script component or UI, others report no stability issues, emphasizing good infrastructure is crucial. While some use it extensively without problems, a few mention occasional false alarms. It scores highly for stability with room for performance improvements.