Technology expertise
Decinova audits your SSIS packages through automated reverse-engineering, maintains your SQL Server environments daily, and migrates your ETL to DBT and Microsoft Fabric using our proprietary converter.
Our SSIS expertise
SSIS is the historical ETL engine of thousands of enterprises. DTSX packages accumulated over years, critical data flows feeding production reporting, SQL Agent jobs running every night. This legacy estate works — but it is increasingly difficult to maintain, document, and evolve.
Decinova covers the full stack: corrective and adaptive maintenance of SSIS packages, SQL Agent job optimisation, SQL Server data warehouse maintenance, and automated migration to modern platforms (DBT, Snowflake, Fabric).
But our real differentiator is our ability to understand this estate at scale using our proprietary reverse-engineering tools.
Corrective and adaptive DTSX package maintenance. Debugging, refactoring, new flow creation, error handling and logging.
Stored procedure, function, and view maintenance. Query optimisation, index management, performance monitoring.
SSAS cube maintenance (multidimensional and tabular) and SSRS reports. Processing and rendering time optimisation.
SQL Agent job monitoring and optimisation. Package dependency management, alerting, 24/7 incident management.
Proprietary tool Decinova
How many SSIS packages do you have in production? Which flows are still in use? Which tables are actually referenced? Where is the technical technical debt ?
Most organisations cannot answer these questions. Documentation is obsolete or non-existent, the original developers have left, and the estate has grown organically without governance. Our scanner fixes this in under 48 hours.
Our reverse-engineering scanner solves this problem. It automatically analyses every DTSX file in your SSIS catalogue and extracts a complete map: flows, dependencies, dead code, technical debt score per component.
1,247 packages analysed, 3,891 data flows mapped, 682 tables referenced — in under 48 hours. This is the result of a real audit conducted for a banking client with our proprietary scanner.
The deliverable: a comprehensive report with a technical debt score per component and a prioritised migration plan. This diagnostic is the starting point for any informed decision — maintain, optimise, or migrate.
Status overview · February 2026
Microsoft continues to include SSIS in SQL Server but with increasing deprecations. The strategic direction is clear: Fabric and Azure Data Factory are the future. The question is not whether to migrate, but when and how.
Mature and widely deployed version. The stable foundation for SSIS environments in production today. Microsoft mainstream support runs until 2028.
GA late 2025. SSIS remains included but with major removals: 32-bit mode dropped, Oracle connector removed, Attunity CDC removed, Package Store deprecated. A strong signal that SSIS is in maintenance mode.
Microsoft is clearly pushing toward Fabric and Azure Data Factory. SSIS packages can run in ADF (lift & shift), but the long-term target is native Fabric pipelines and DBT for transformations.
| Component | Status | Alternative | Impact |
|---|---|---|---|
| Mode 32-bit (SSIS Engine) | Removed | 64-bit only mode | High |
| Microsoft Connector for Oracle | Retired | ADO.NET / Fabric Data Factory | High |
| CDC Attunity (Oracle) | Retired | Fabric CDC / Debezium | High |
| SSIS Package Store | Deprecated | SSISDB Catalog | Medium |
| System.Data.SqlClient | Deprecated | Microsoft.Data.SqlClient | Medium |
| SDS Connection Type | Deprecated | ADO.NET Connection Type | Low |
| Hadoop Tasks (Hive, Pig, HDFS) | Retired | Fabric Lakehouse / Spark | Low |
| Legacy Integration Services Service | Deprecated | SSISDB via SSMS | Low |
SSIS has no official end-of-life date, but the signal is clear: Microsoft invests in Fabric, not SSIS. The deprecations in SQL Server 2025 confirm this trajectory. Organisations with 100+ packages should plan their migration now.
Migration SSIS
Manually migrating hundreds of SSIS packages to DBT is a multi-month project: each package must be dissected, understood, and rewritten. With complex legacy estates, this approach is slow, expensive, and error-prone.
Our proprietary converter automates the translation. It analyses each DTSX package, extracts business logic from data flows and transformations, and generates the equivalent DBT model with tests and documentation.
What takes months of manual rewriting is automated in days. The converter preserves business logic and generates clean, tested, documented DBT models compatible with Snowflake or Fabric.
Of course, not all SSIS components translate automatically — custom Script Tasks, third-party components, and some complex transformations require manual rework. But even for these, the converter provides a detailed analysis that accelerates the work.
audit (Pillar 01) → wave-based migration → parallel legacy/cloud run → cutover. Production never stops.
Related articles
Let’s talk about your SSIS environment
Whether you need to maintain your SSIS estate, understand your technical debt, or plan your migration to DBT and Fabric, we have the expertise and tools to help.