Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
APPLIES TO:
Azure Data Factory
Azure Synapse Analytics
Tip
Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!
This article lists all built-in and preinstalled components, such as clients, drivers, providers, connection managers, data sources/destinations/transformations, and tasks on SSIS Integration Runtime (IR) in Azure Data Factory (ADF) or Synapse Pipelines. To provision SSIS IR in ADF, follow the instructions in Provision Azure-SSIS IR.
Name | Version |
---|---|
Windows | Windows Server 2019 |
.NET Framework | 4.7.2 |
Type | Name - Version - Platform |
---|---|
Built-in clients/drivers/providers | Access Database Engine 2016 Redistributable - RTM - X64 Microsoft Analysis Management Objects - 15.0.2000.443 - X64 Microsoft Analysis Services OLEDB Provider - 15.0.2000.443 - X64 Microsoft SQL Server 2012 Native Client - 11.4.7462.6 - X64 Microsoft ODBC Driver 13 for SQL Server - 14.0.900.902 - X64 Microsoft OLEDB Driver 18 for SQL Server - 18.6.5 - X64 Microsoft OLEDB Provider for DB2 - 6.0 - X64 SharePoint Online Client Components SDK - 15.4711.1001 - X64 |
To install additional custom/Open Source/3rd party components on your SSIS IR, follow the instructions in Customize Azure-SSIS IR.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Execute existing SSIS packages in Azure Data Factory - Training
Execute existing SSIS packages in Azure Data Factory or Azure Synapse Pipeline
Certification
Microsoft Certified: Azure Data Engineer Associate - Certifications
Demonstrate understanding of common data engineering tasks to implement and manage data engineering workloads on Microsoft Azure, using a number of Azure services.
Documentation
Customize the setup for an Azure-SSIS Integration Runtime - Azure Data Factory
This article describes how to use the custom setup interface for an Azure-SSIS Integration Runtime to install additional components or change settings
Use the Execute SSIS Package activity from the portal - Azure Data Factory
This article describes how to run a SQL Server Integration Services (SSIS) package in an Azure Data Factory pipeline by using the Execute SSIS Package activity and the Azure Data Factory Studio portal.
Troubleshoot SSIS Integration Runtime management - Azure Data Factory
This article provides troubleshooting guidance for management issues of SSIS Integration Runtime (SSIS IR)