SSIS Reviews

SSIS proves to be a cost-effective choice for many, especially with its lack of additional fees beyond the SQL Server license. Users report it significantly enhances data management efficiency and results in high returns. While some believe a larger budget could have allowed for a different tool, others find it tremendously efficient, saving substantial money even though an exact figure isn't provided. The overall sentiment reflects satisfaction and positive returns from using SSIS.

Enterprise users reported that SSIS is economically advantageous, often bundled with SQL Server licenses at no extra cost. While specific add-ons may increase expenses, SSIS generally offers favorable pricing compared to competitors like Informatica and Talend. Many organizations appreciate the value it provides, especially when leveraging Microsoft technologies. Licensing terms vary, depending on company agreements with Microsoft, but overall, SSIS proves cost-effective, aligning well with existing SQL Server infrastructure, making it a practical choice for enterprises.

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

Entities utilize SSIS for data movement, transformation, and integration across environments, including data warehousing, reporting, and business intelligence tasks. It supports ETL processes for transferring data between systems, cleansing, and transforming data for analytics. Users implement it for applications in migration, data mart creation, and integration between various databases. They frequently deploy SSIS for creating reproducible patterns in ETL and supporting data-driven decision-making frameworks.

Customer service for SSIS is generally rated poorly. Technical support is often deemed good, but many users find solutions independently or through online resources. Users report infrequent direct interaction with Microsoft support, citing self-resolution via forums and web searches. Some find Microsoft's support costly and slow to respond, while others appreciate accessible community-based information. Business partnerships may enhance support experiences, yet many find external resources like SQLServerCentral and Stack Overflow sufficient for resolving issues.

Many found SSIS's initial setup straightforward and uncomplicated, often completed within a few hours or a day. A small team can efficiently handle deployment and maintenance. Some noted the need for additional components like Visual Studio add-ons, which can add complexity. While most users experienced a simple installation, a few faced challenges, especially with larger deployments or security configurations. With adequate expertise, setup was generally rated easy.

SSIS is generally considered scalable, with many suggesting it suits small to medium enterprises. Some have handled substantial data volumes effectively, while others mention limitations with very large datasets. Scalability often depends on the underlying infrastructure, with horizontal scaling being a challenge. Expanding usage is usually feasible, although Azure Data Factory offers better scalability. Despite occasional performance issues with large data, SSIS remains a reliable choice for various implementations.

Many users find SSIS stable and reliable, praising its consistent performance and low incidence of bugs. However, a few encounter issues, such as false alarms and performance problems with extensive ETL data processing. SSIS generally works well with proper infrastructure setup. Some mention potential performance improvements and occasional UI-related challenges. SSIS is considered mature and suitable for long-term use in various business environments.