Proposed Pull Request Change

📄 Document Links

View on GitHub View on Microsoft Learn

--- title: Built-in and preinstalled components on Azure-SSIS Integration Runtime description: List all built-in and preinstalled components, such as clients, drivers, providers, connection managers, data sources/destinations/transformations, and tasks on Azure-SSIS Integration Runtime. ms.subservice: integration-services ms.topic: conceptual author: chugugrace ms.author: chugu ms.custom: devx-track-dotnet ms.date: 01/05/2024 --- # Built-in and preinstalled components on Azure-SSIS Integration Runtime [!INCLUDE[appliesto-adf-asa-md](includes/appliesto-adf-asa-md.md)] 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](./tutorial-deploy-ssis-packages-azure.md). ## OS and .NET Framework on Azure-SSIS IR | Name | Version | |------|---------| | **Windows** | Windows Server 2019 | | **.NET Framework** | 4.7.2 | ## Built-in and preinstalled clients, drivers, and providers on Azure-SSIS IR | Type | Name - Version - Platform | |------|---------------------------| | **Built-in clients/drivers/providers** | *Access Database Engine 2016 Redistributable* - RTM - X64<br/><br/>*Microsoft Analysis Management Objects* - 15.0.2000.443 - X64<br/><br/>*Microsoft Analysis Services OLEDB Provider* - 15.0.2000.443 - X64<br/><br/>*Microsoft SQL Server 2012 Native Client* - 11.4.7462.6 - X64<br/><br/>*Microsoft ODBC Driver 13 for SQL Server* - 14.0.900.902 - X64<br/><br/>*Microsoft OLEDB Driver 18 for SQL Server* - 18.6.5 - X64<br/><br/>*Microsoft OLEDB Provider for DB2* - 6.0 - X64<br/><br/>*SharePoint Online Client Components SDK* - 15.4711.1001 - X64 | ## Built-in and preinstalled connection managers on Azure-SSIS IR | Type | Name | |------|------| | **Built-in connection managers** | [ADO Connection Manager](/sql/integration-services/connection-manager/ado-connection-manager)<br/><br/>[ADO.NET Connection Manager](/sql/integration-services/connection-manager/ado-net-connection-manager)<br/><br/>[Analysis Services Connection Manager](/sql/integration-services/connection-manager/analysis-services-connection-manager)<br/><br/>[Excel Connection Manager](/sql/integration-services/connection-manager/excel-connection-manager)<br/><br/>[File Connection Manager](/sql/integration-services/connection-manager/file-connection-manager)<br/><br/>[Flat File Connection Manager](/sql/integration-services/connection-manager/flat-file-connection-manager)<br/><br/>[FTP Connection Manager](/sql/integration-services/connection-manager/ftp-connection-manager)<br/><br/>[Hadoop Connection Manager](/sql/integration-services/connection-manager/hadoop-connection-manager)<br/><br/>[HTTP Connection Manager](/sql/integration-services/connection-manager/http-connection-manager)<br/><br/>[MSMQ Connection Manager](/sql/integration-services/connection-manager/msmq-connection-manager)<br/><br/>[Multiple Files Connection Manager](/sql/integration-services/connection-manager/multiple-files-connection-manager)<br/><br/>[Multiple Flat Files Connection Manager](/sql/integration-services/connection-manager/multiple-flat-files-connection-manager)<br/><br/>[ODBC Connection Manager](/sql/integration-services/connection-manager/odbc-connection-manager)<br/><br/>[OLEDB Connection Manager](/sql/integration-services/connection-manager/ole-db-connection-manager)<br/><br/>[SAP BW Connection Manager](/sql/integration-services/connection-manager/sap-bw-connection-manager) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[SMO Connection Manager](/sql/integration-services/connection-manager/smo-connection-manager)<br/><br/>[SMTP Connection Manager](/sql/integration-services/connection-manager/smtp-connection-manager)<br/><br/>[SQL Server Compact Edition Connection Manager](/sql/integration-services/connection-manager/sql-server-compact-edition-connection-manager)<br/><br/>[WMI Connection Manager](/sql/integration-services/connection-manager/wmi-connection-manager) | | **Preinstalled connection managers ([Azure Feature Pack](/sql/integration-services/azure-feature-pack-for-integration-services-ssis))** | [Azure Data Lake Analytics Connection Manager](/sql/integration-services/connection-manager/azure-data-lake-analytics-connection-manager)<br/><br/>[Azure Data Lake Store Connection Manager](/sql/integration-services/connection-manager/azure-data-lake-store-connection-manager)<br/><br/>[Azure HDInsight Connection Manager](/sql/integration-services/connection-manager/azure-hdinsight-connection-manager)<br/><br/>[Azure Resource Manager Connection Manager](/sql/integration-services/connection-manager/azure-resource-manager-connection-manager)<br/><br/>[Azure Storage Connection Manager](/sql/integration-services/connection-manager/azure-storage-connection-manager)<br/><br/>[Azure Subscription Connection Manager](/sql/integration-services/connection-manager/azure-subscription-connection-manager) | ## Built-in and preinstalled data sources on Azure-SSIS IR | Type | Name | |------|------| | **Built-in data sources** | [ADO.NET Source](/sql/integration-services/data-flow/ado-net-source)<br/><br/>[CDC Source](/sql/integration-services/data-flow/cdc-source) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[Excel Source](/sql/integration-services/data-flow/excel-source)<br/><br/>[Flat File Source](/sql/integration-services/data-flow/flat-file-source)<br/><br/>[HDFS File Source](/sql/integration-services/data-flow/hdfs-file-source)<br/><br/>[OData Source](/sql/integration-services/data-flow/odata-source)<br/><br/>[ODBC Source](/sql/integration-services/data-flow/odbc-source)<br/><br/>[OLEDB Source](/sql/integration-services/data-flow/ole-db-source)<br/><br/>[Raw File Source](/sql/integration-services/data-flow/raw-file-source)<br/><br/>[SAP BW Source](/sql/integration-services/data-flow/sap-bw-source) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[XML Source](/sql/integration-services/data-flow/xml-source) | | **Preinstalled data sources ([Azure Feature Pack](/sql/integration-services/azure-feature-pack-for-integration-services-ssis) + [Power Query Source](/sql/integration-services/data-flow/power-query-source))** | [Azure Blob Source](/sql/integration-services/data-flow/azure-blob-source)<br/><br/>[Azure Data Lake Store Source](/sql/integration-services/data-flow/azure-data-lake-store-source)<br/><br/>[Flexible File Source](/sql/integration-services/data-flow/flexible-file-source)<br/><br/>[Power Query Source](/sql/integration-services/data-flow/power-query-source) | ## Built-in and preinstalled data destinations on Azure-SSIS IR | Type | Name | |------|------| | **Built-in data destinations** | [ADO.NET Destination](/sql/integration-services/data-flow/ado-net-destination)<br/><br/>[Data Mining Model Training Destination](/sql/integration-services/data-flow/data-mining-model-training-destination) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[DataReader Destination](/sql/integration-services/data-flow/datareader-destination)<br/><br/>[Data Streaming Destination](/sql/integration-services/data-flow/data-streaming-destination)<br/><br/>[Dimension Processing Destination](/sql/integration-services/data-flow/dimension-processing-destination) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[Excel Destination](/sql/integration-services/data-flow/excel-destination)<br/><br/>[Flat File Destination](/sql/integration-services/data-flow/flat-file-destination)<br/><br/>[HDFS File Destination](/sql/integration-services/data-flow/hdfs-file-destination)<br/><br/>[ODBC Destination](/sql/integration-services/data-flow/odbc-destination)<br/><br/>[OLEDB Destination](/sql/integration-services/data-flow/ole-db-destination)<br/><br/>[Partition Processing Destination](/sql/integration-services/data-flow/partition-processing-destination) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[Raw File Destination](/sql/integration-services/data-flow/raw-file-destination)<br/><br/>[Recordset Destination](/sql/integration-services/data-flow/recordset-destination)<br/><br/>[SAP BW Destination](/sql/integration-services/data-flow/sap-bw-destination) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[SQL Server Compact Edition Destination](/sql/integration-services/data-flow/sql-server-compact-edition-destination)<br/><br/>[SQL Server Destination](/sql/integration-services/data-flow/sql-server-destination) | | **Preinstalled data destinations ([Azure Feature Pack](/sql/integration-services/azure-feature-pack-for-integration-services-ssis))** | [Azure Blob Destination](/sql/integration-services/data-flow/azure-blob-destination)<br/><br/>[Azure Data Lake Store Destination](/sql/integration-services/data-flow/azure-data-lake-store-destination)<br/><br/>[Flexible File Destination](/sql/integration-services/data-flow/flexible-file-destination) | ## Built-in and preinstalled data transformations on Azure-SSIS IR | Type | Name | |------|------| | **Built-in auditing transformations** | [Audit Transformation](/sql/integration-services/data-flow/transformations/audit-transformation)<br/><br/>[Row Count Transformation](/sql/integration-services/data-flow/transformations/row-count-transformation) | | **Built-in BI transformations** | [Data Mining Query Transformation](/sql/integration-services/data-flow/transformations/data-mining-query-transformation) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[DQS Cleansing Transformation](/sql/integration-services/data-flow/transformations/dqs-cleansing-transformation)<br/><br/>[Fuzzy Grouping Transformation](/sql/integration-services/data-flow/transformations/fuzzy-grouping-transformation) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[Fuzzy Lookup Transformation](/sql/integration-services/data-flow/transformations/fuzzy-lookup-transformation) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[Term Extraction Transformation](/sql/integration-services/data-flow/transformations/term-extraction-transformation) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[Term Lookup Transformation](/sql/integration-services/data-flow/transformations/term-lookup-transformation) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md)) | | **Built-in row transformations** | [Character Map Transformation](/sql/integration-services/data-flow/transformations/character-map-transformation)<br/><br/>[Copy Column Transformation](/sql/integration-services/data-flow/transformations/copy-column-transformation)<br/><br/>[Data Conversion Transformation](/sql/integration-services/data-flow/transformations/data-conversion-transformation)<br/><br/>[Derived Column Transformation](/sql/integration-services/data-flow/transformations/derived-column-transformation)<br/><br/>[Export Column Transformation](/sql/integration-services/data-flow/transformations/export-column-transformation)<br/><br/>[Import Column Transformation](/sql/integration-services/data-flow/transformations/import-column-transformation)<br/><br/>[OLE DB Command Transformation](/sql/integration-services/data-flow/transformations/ole-db-command-transformation)<br/><br/>[Script Component](/sql/integration-services/data-flow/transformations/script-component) | | **Built-in rowset transformations** | [Aggregate Transformation](/sql/integration-services/data-flow/transformations/aggregate-transformation)<br/><br/>[Percentage Sampling Transformation](/sql/integration-services/data-flow/transformations/percentage-sampling-transformation)<br/><br/>[Pivot Transformation](/sql/integration-services/data-flow/transformations/pivot-transformation)<br/><br/>[Row Sampling Transformation](/sql/integration-services/data-flow/transformations/row-sampling-transformation)<br/><br/>[Sort Transformation](/sql/integration-services/data-flow/transformations/sort-transformation)<br/><br/>[Unpivot Transformation](/sql/integration-services/data-flow/transformations/unpivot-transformation) | | **Built-in split and join transformations** | [Balanced Data Distributor Transformation](/sql/integration-services/data-flow/transformations/balanced-data-distributor-transformation)<br/><br/>[Cache Transform](/sql/integration-services/data-flow/transformations/cache-transform)<br/><br/>[CDC Splitter](/sql/integration-services/data-flow/cdc-splitter) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[Conditional Split Transformation](/sql/integration-services/data-flow/transformations/conditional-split-transformation)<br/><br/>[Lookup Transformation](/sql/integration-services/data-flow/transformations/lookup-transformation)<br/><br/>[Merge Join Transformation](/sql/integration-services/data-flow/transformations/merge-join-transformation)<br/><br/>[Merge Transformation](/sql/integration-services/data-flow/transformations/merge-transformation)<br/><br/>[Multicast Transformation](/sql/integration-services/data-flow/transformations/multicast-transformation)<br/><br/>[Slowly Changing Dimension Transformation](/sql/integration-services/data-flow/transformations/slowly-changing-dimension-transformation)<br/><br/>[Union All Transformation](/sql/integration-services/data-flow/transformations/union-all-transformation) | ## Built-in and preinstalled tasks on Azure-SSIS IR | Type | Name | |------|------| | **Built-in Analysis Services tasks** | [Analysis Services Execute DDL Task](/sql/integration-services/control-flow/analysis-services-execute-ddl-task)<br/><br/>[Analysis Services Processing Task](/sql/integration-services/control-flow/analysis-services-processing-task)<br/><br/>[Data Mining Query Task](/sql/integration-services/control-flow/data-mining-query-task) | | **Built-in data flow tasks** | [Data Flow Task](/sql/integration-services/control-flow/data-flow-task) | | **Built-in data preparation tasks** | [CDC Control Task](/sql/integration-services/control-flow/cdc-control-task) ([Enterprise Edition](./how-to-configure-azure-ssis-ir-enterprise-edition.md))<br/><br/>[Check Database Integrity Task](/sql/integration-services/control-flow/check-database-integrity-task)<br/><br/>[Data Profiling Task](/sql/integration-services/control-flow/data-profiling-task-and-viewer)<br/><br/>[File System Task](/sql/integration-services/control-flow/file-system-task)<br/><br/>[FTP Task](/sql/integration-services/control-flow/ftp-task)<br/><br/>[Hadoop File System Task](/sql/integration-services/control-flow/hadoop-file-system-task)<br/><br/>[Hadoop Hive Task](/sql/integration-services/control-flow/hadoop-hive-task)<br/><br/>[Hadoop Pig Task](/sql/integration-services/control-flow/hadoop-pig-task)<br/><br/>[Web Service Task](/sql/integration-services/control-flow/web-service-task)<br/><br/>[XML Task](/sql/integration-services/control-flow/xml-task) | | **Built-in maintenance tasks** | [Back Up Database Task](/sql/integration-services/control-flow/back-up-database-task)<br/><br/>[Execute T-SQL Statement Task](/sql/integration-services/control-flow/execute-t-sql-statement-task)<br/><br/>[History Cleanup Task](/sql/integration-services/control-flow/history-cleanup-task)<br/><br/>[Maintenance Cleanup Task](/sql/integration-services/control-flow/maintenance-cleanup-task)<br/><br/>[Notify Operator Task](/sql/integration-services/control-flow/notify-operator-task)<br/><br/>[Rebuild Index Task](/sql/integration-services/control-flow/rebuild-index-task)<br/><br/>[Reorganize Index Task](/sql/integration-services/control-flow/reorganize-index-task)<br/><br/>[Select Objects to Transfer](/sql/integration-services/control-flow/select-objects-to-transfer)<br/><br/>[Shrink Database Task](/sql/integration-services/control-flow/shrink-database-task)<br/><br/>[Transfer Database Task](/sql/integration-services/control-flow/transfer-database-task)<br/><br/>[Transfer Error Messages Task](/sql/integration-services/control-flow/transfer-error-messages-task)<br/><br/>[Transfer Jobs Task](/sql/integration-services/control-flow/transfer-jobs-task)<br/><br/>[Transfer Logins Task](/sql/integration-services/control-flow/transfer-logins-task)<br/><br/>[Transfer Master Stored Procedures Task](/sql/integration-services/control-flow/transfer-master-stored-procedures-task)<br/><br/>[Transfer SQL Server Objects Task](/sql/integration-services/control-flow/transfer-sql-server-objects-task)<br/><br/>[Update Statistics Task](/sql/integration-services/control-flow/update-statistics-task) | | **Built-in scripting tasks** | [Script Task](/sql/integration-services/control-flow/script-task) | | **Built-in SQL Server tasks** | [Bulk Insert Task](/sql/integration-services/control-flow/bulk-insert-task)<br/><br/>[Execute SQL Task](/sql/integration-services/control-flow/execute-sql-task) | | **Built-in workflow tasks** | [Execute Package Task](/sql/integration-services/control-flow/execute-package-task)<br/><br/>[Execute Process Task](/sql/integration-services/control-flow/execute-process-task)<br/><br/>[Execute SQL Server Agent Job Task](/sql/integration-services/control-flow/execute-sql-server-agent-job-task)<br/><br/>[Expression Task](/sql/integration-services/control-flow/expression-task)<br/><br/>[Message Queue Task](/sql/integration-services/control-flow/message-queue-task)<br/><br/>[Send Mail Task](/sql/integration-services/control-flow/send-mail-task)<br/><br/>[WMI Data Reader Task](/sql/integration-services/control-flow/wmi-data-reader-task)<br/><br/>[WMI Event Watcher Task](/sql/integration-services/control-flow/wmi-event-watcher-task) | | **Preinstalled tasks ([Azure Feature Pack](/sql/integration-services/azure-feature-pack-for-integration-services-ssis))** | [Azure Blob Download Task](/sql/integration-services/control-flow/azure-blob-download-task)<br/><br/>[Azure Blob Upload Task](/sql/integration-services/control-flow/azure-blob-upload-task)<br/><br/>[Azure Data Lake Analytics Task](/sql/integration-services/control-flow/azure-data-lake-analytics-task)<br/><br/>[Azure Data Lake Store File System Task](/sql/integration-services/control-flow/azure-data-lake-store-file-system-task)<br/><br/>[Azure HDInsight Create Cluster Task](/sql/integration-services/control-flow/azure-hdinsight-create-cluster-task)<br/><br/>[Azure HDInsight Delete Cluster Task](/sql/integration-services/control-flow/azure-hdinsight-delete-cluster-task)<br/><br/>[Azure HDInsight Hive Task](/sql/integration-services/control-flow/azure-hdinsight-hive-task)<br/><br/>[Azure HDInsight Pig Task](/sql/integration-services/control-flow/azure-hdinsight-pig-task)<br/><br/>[Azure SQL Azure Synapse Analytics Upload Task](/sql/integration-services/control-flow/azure-sql-dw-upload-task)<br/><br/>[Flexible File Task](/sql/integration-services/control-flow/flexible-file-task) | ## Related content To install additional custom/Open Source/3rd party components on your SSIS IR, follow the instructions in [Customize Azure-SSIS IR](./how-to-configure-azure-ssis-ir-custom-setup.md).