SSIS 2025: Securing ETL and Enabling the Transition to Microsoft Fabric
SQL Server Integration Services (SSIS) 2025 is now Generally Available (GA), representing a significant step forward in Microsoft’s ETL strategy. This release modernizes the platform to meet both on-premises and cloud-native requirements, including seamless integration with Microsoft Fabric.
For enterprises, this GA release introduces the following changes:
- Security is strengthened with Microsoft Entra ID authentication and TLS 1.3 along with TDS 8.0 Strict Encryption.
- Key components such as the 32-bit execution mode, Legacy Integration Services Service, SSIS Package Store, Attunity CDC components, and the Microsoft Connector for Oracle are deprecated or removed.
KingswaySoft supports this transition by ensuring that existing SSIS packages remain functional, secure, and fully optimized for migration to Fabric.
KingswaySoft SSIS Solutions ensure this transition is codeless, compliant, and seamless.
Enterprise-Grade Security: Entra ID and the New Standard
The most impactful change in SSIS 2025 is the mandatory upgrade to modern security protocols, driven by the broader Microsoft enterprise focus on identity and encrypted data in transit.
- Mandatory Entra ID Authentication: SSIS 2025 requires integration with Microsoft Entra ID (formerly Azure AD) for centralized, identity-based authentication when connecting to modern data sources, particularly those in the Microsoft Fabric ecosystem. Legacy authentication methods are being phased out.
- Enforced TLS 1.3 and TDS 8.0: The new SSIS version leverages the Microsoft.Data.SqlClient provider, which enforces the use of TLS 1.3 and TDS 8.0 Strict Encryption. This ensures that all data moved by SSIS is encrypted by default, aligning with the highest SQL Server 2025 security standards for both on-premises and hybrid deployments.
KingswaySoft Solution: Codeless Compliance
Dealing with Entra ID's complexity (Client IDs, Tenant IDs, Secrets, and token generation) is notoriously difficult to set up manually and can be a major development roadblock. Our SSIS Integration Toolkit is designed to abstract this complexity, the messy technical details, so your team can achieve full security compliance without writing a single line of code.
We provide a simple interface that handles the difficult security handshakes behind the scenes,
so you can focus on moving your data, not managing code.
KingswaySoft's SQL Server Connection Manager simplifies the setup for all SQL Server 2025 and Fabric endpoints, allowing developers to configure the required OAuth/Entra ID authentication flow (e.g., Authorization Code, Client Secret) through a simple, robust UI, eliminating the need for custom scripting.
The Fabric Connection: Your Modernization On-Ramp
The strategic driver for many of SSIS 2025's changes is providing a clear, supported path to the Microsoft Fabric platform.
Microsoft supports a "lift-and-shift" capability that allows companies to reuse existing SSIS package logic by executing them within the Fabric Data Factory experience, thus avoiding a complete rewrite of complex ETL workflows.
When targeting Fabric Data Warehouse, SSIS packages must be updated to align with Fabric’s requirements. This includes adhering to Microsoft Entra ID authentication, as Fabric does not support SQL or Windows authentication, and using high-performance data loads with T-SQL COPY INTO, replacing older fast-insert or BCP methods.
These modifications ensure that SSIS packages comply with Fabric’s security and data integration architecture.
Read our Work with Microsoft Fabric Warehouse Using KingswaySoft Blog Post
Read Blog Post
Seamless Connectivity to Fabric Endpoints with KinsgwaySoft
The Fabric platform offers two primary SQL endpoints:
Fabric Data Warehouse
SQL Analytics Endpoint
KingswaySoft's components are engineered to connect to both endpoints seamlessly using the same SQL Endpoint Connection String retrieved from the Fabric workspace.
This flexibility allows KingswaySoft users to efficiently run DML/DDL operations on the Warehouse and perform read-only queries against the Lakehouse endpoint, streamlining hybrid integration workflows.
Planning Your Transition: Mandatory Upgrades and Deprecation
To maintain a secure and compliant platform, SSIS 2025 introduces several breaking changes that must be addressed:
- Removal of 32-bit Execution: All packages must now execute in 64-bit mode. This is a breaking change for any custom or third-party components that were only 32-bit compatible.
- Deprecation of SSIS Package Store: The legacy SSIS Package Store is removed, requiring all deployments to utilize the SSIS Catalog (SSISDB).
- Removal of Legacy Connectors: Components like the Change Data Capture (CDC) components by Attunity and the Microsoft Connector for Oracle are no longer included in SSIS 2025. Users are encouraged to explore modern integration options with Data Factory in Microsoft Fabric.
KingswaySoft's Solution:
Comprehensive Component Replacement
For organizations with thousands of packages relying on deprecated connectors, this presents a significant challenge. To maintain business continuity and avoid costly package rewrites, a strategic component replacement is required.
KingswaySoft's SSIS Integration Toolkit Ultimate Edition provides a single, cost-effective solution to bridge this gap. By offering a vast library of codeless, robust connectors for systems ranging from Dynamics 365 and Dataverse to Salesforce and SAP, KingswaySoft helps ETL processes continue to run while supporting 64-bit execution and Microsoft Entra ID authentication, in line with SSIS 2025 standards.
Don't let the mandatory security and component changes in SSIS 2025 create uncertainty or force a rushed modernization decision.
The shift to Microsoft Entra ID and the deprecation of legacy components (like the 32-bit runtime and Attunity connectors) represent the highest-risk points in your ETL system.
KingswaySoft helps turn this risk into a reliable part of your transition plan.
By implementing a proactive strategy and utilizing the specialized connectors within our SSIS Integration Toolkits and SSIS Productivity Pack, all included with our Ultimate Edition, you can transform these mandatory changes into a powerful opportunity for modernization. Secure your entire data supply chain, replace all deprecated connectors, and gain codeless, compliant access to Microsoft Fabric and SQL Server 2025, while aligning with Entra ID authentication and 64-bit execution requirements.
Start planning your seamless, future-proof data journey today.
Get In Touch Download SolutionAbout KingswaySoft
KingswaySoft offers robust data enablement solutions that simplify complex integration scenarios and enhance data connectivity. These include our recently introduced JDBC Driver Pack, and over 300 SSIS components across diverse categories, such as data masking and anonymization, duplicate detection, data comparison, data profiling, advanced expression, encryption and compression, JSON & XML processing, SFTP/FTPS, and message queuing, to name a few. Many other premium components support in delivering a rapid ETL development experience using Microsoft Visual Studio and SQL Server Integration Services (SSIS) as the platform.
Our solution also includes support for connecting to NoSQL databases, cloud storage services, REST APIs, and virtually any other API or web service endpoint (SOAP or REST). Connectivity solutions are also available for facilitating data integration with enterprise applications such as Microsoft Dynamics 365, Active Directory, HubSpot, Microsoft SharePoint, Salesforce, SAP, and many more. Similarly, REST connections are available for numerous applications, including LinkedIn, Facebook Messenger, Acumatica, Zoom, Shopify, ServiceNow, and Zendesk, to name a few.
Get in touch with an expert to secure
your risk-free SSIS migration and integration plan.
Our expert team will be available to answer any questions.
FAQ
SSIS 2025 significantly improves security by integrating Microsoft Entra ID (formerly Azure AD) for centralized, identity-based authentication, a requirement for modern cloud systems. It also leverages the Microsoft.Data.SqlClient provider to enforce TLS 1.3 and TDS 8.0 Strict Encryption, ensuring all data is protected in transit and aligning with the latest SQL Server 2025 security standards.
Microsoft supports a "lift-and-shift" capability that allows existing SSIS packages to be reused and executed within Microsoft Fabric Data Factory. This avoids rewriting complex ETL logic. However, packages must be modernized to use Microsoft Entra ID authentication and adopt high-performance load methods like T-SQL COPY INTO when targeting Fabric Data Warehouse.
The major breaking changes in SSIS 2025 include the removal of 32-bit execution mode and the deprecation of the SSIS Package Store. The new standard requires all packages to run in 64-bit mode and be deployed to the SSIS Catalog (SSISDB). Legacy components, such as the CDC Components by Attunity, are also moved, encouraging the use of modern cloud-native or ADO.NET solutions.