Hadoop and HDFS Support in Integration Services (SSIS)

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

SQL Server 2016 Integration Services (SSIS) includes the following components that provide support for Hadoop and HDFS on premises.

For info about the Integration Services components that support HDInsight and other features of Microsoft Azure, see Azure Feature Pack for Integration Services (SSIS).

• Connection manager

  • Hadoop Connection Manager

• Control flow - Tasks

  • Hadoop File System Task

  • Hadoop Hive Task

  • Hadoop Pig Task

• Data flow - Data source and destination

  • HDFS File Source

  • HDFS File Destination