Note: This list may not be complete. No component, listed or unlisted, may be used outside of
the technology in which it is released. The usage decision for a component is found in the Decision
and Decision Constraints.
Azure Blob Destination |
The Azure Blob Destination component enables an Server Integration Services (SSIS) package to write data to an Azure blob. The supported file formats are: CSV and AVRO. |
Azure Blob Download Task |
The Azure Blob Download Task enables an Server Integration Services (SSIS) package to download files from Azure Blob Storage. |
Azure Blob Source |
The Azure Blob Source component enables a Server Integration Services (SSIS) package to read data from an Azure blob. The supported file formats are: CSV and AVRO. |
Azure Blob Upload Task |
The Azure Blob Upload Task enables a Server Integration Services (SSIS) package to upload files to Azure Blob Storage. |
Azure Data Lake Analytics connection manager |
The Data Lake Analytics connection manager is a component of the Structured Query Language (SQL) Server Integration Services (SSIS) Feature Pack for Azure. |
Azure Data Lake Analytics task |
You can submit U-SQL jobs to Azure Data Lake Analytics service with the Data Lake Analytics task. This task is a component of the Structured Query Language (SQL) Server Integration Services (SSIS) feature pack for Azure. |
Azure Data Lake Store Connection Manager |
The Azure Data Lake Store Connection Manager is a component of the Structured Query Language (SQL) Server Integration Services (SSIS) Feature Pack for Azure. |
Azure Data Lake Store Destination |
The Azure Data Lake Store Destination component enables a Server Integration Services (SSIS) package to write data to an Azure Data Lake Store. The supported file formats are: Text, Avro, and Optimized Row Columnar (ORC). |
Azure Data Lake Store File System Task |
The Azure Data Lake Store File System Task lets users perform various file system operations on Azure Data Lake Store. |
Azure Data Lake Store Source |
The Azure Data Lake Store Source component enables a Server Integration Services (SSIS) package to read data from an Azure Data Lake Store. The supported file formats are: Text and Avro. |
Azure HDInsight Connection Manager |
The Azure HDInsight Connection Manager enables a Server Integration Services (SSIS) package to connect to an Azure HDInsight cluster. |
Azure HDInsight Create Cluster Task |
The Azure HDInsight Create Cluster Task enables a Server Integration Services (SSIS) package to create an Azure HDInsight cluster in the specified Azure subscription and resource group. |
Azure HDInsight Hive Task |
To add an Azure HDInsight Hive Task, drag-drop it to the Server Integration Services (SSIS) Designer, and double-click or right-click and click Edit to see the following Azure HDInsight Hive Task Editor dialog box. |
Azure HDInsight Pig Task |
To add an Azure HDInsight Pig Task, drag-drop it to the Server Integration Services (SSIS) Designer, and double-click or right-click and click Edit to see the following Azure HDInsight Pig Task Editor dialog box. |
Azure Resource Manager Connection Manager |
The Azure Resource Manager Connection Manager enables a Server Integration Services (SSIS) package to manage Azure resources using a service principal. |
Azure Storage connection manager |
The Azure Storage connection manager enables a Structured Query Language (SQL) Server Integration Services (SSIS) package to connect to an Azure Storage account. The connection manager is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure. |
Azure Subscription Connection Manager |
The Azure Subscription connection manager enables an SSIS package to connect to an Azure subscription by using the values you specify for the properties: Azure Subscription Identification (ID) and Management Certificate. |
Azure Synapse Analytics Task |
The Azure Synapse Analytics Task enables a Server Integration Services (SSIS) package to copy tabular data to Azure Synapse Analytics dedicated SQL pool from file system or Azure Blob Storage. The task leverages PolyBase to improve performance, as described in the article Azure Synapse Analytics Loading Patterns and Strategies. |
Flexible File Destination |
The Flexible File Destination component enables a Server Integration Services (SSIS) package to write data to various supported storage services. |
Flexible File Source |
To see the editor for the Flexible File Source, drag and drop Flexible File Source on the data flow designer and double-click it to open the editor. |
Flexible File Task |
To add a Flexible File Task to a package, drag it from Server Integration Services (SSIS) Toolbox to the designer canvas. Then double-click the task, or right-click the task and select Edit, to open the Flexible File Task Editor dialog box. |