SSIS Tasks

  Containers:-

Container	Description
Foreach Loop Container	Runs a control flow repeatedly by using an enumerator.
For Loop Container	Runs a control flow repeatedly by testing a condition.
Sequence Container	Groups tasks and containers into control flows that are subsets of the package control flow.
Task Host Container	Provides services to a single task.
Group Container	Groups tasks and containers into control flows that are subsets of the package control flow.

Tasks:-

Type	Tasks
Data Flow Task:-	Data Flow Task - The task that runs data flows to extract data, apply column level transformations, and load data. Contains Source, Transformation, Destination
Data Preparation Tasks	File System Task FTP Task Web Service Task XML Task Data Profiling Task Hadoop File System Task Hadoop Hive Task Hadoop Pig Task
Workflow Tasks	Execute Package Task Execute Process Task Expression Task Message Queue Task Send Mail Task WMI Data Reader Task WMI Event Watcher Task
SQL Server Tasks	Bulk Insert Task CDC Control Task Execute SQL Task Transfer Database Task Transfer Error Messages Task Transfer Jobs Task Transfer Logins Task Transfer Master Stored Procedures Task Transfer SQL Server Objects Task
Scripting Tasks	Script Task
Analysis Services Tasks	Analysis Services Execute DDL Task, Analysis Services Processing Task, Data Mining Query Task
Maintenance Tasks	Back Up Database Task Check Database Integrity Task Execute SQL Server Agent Job Task Execute T-SQL Statement Task History Cleanup Task Maintenance Cleanup Task Notify Operator Task Rebuild Index Task Reorganize Index Task Shrink Database Task Update Statistics Task
Custom Tasks	Custom Tasks
2016 - Azure Tasks	Azure Blob Upload Task Azure Blob Download Task Azure HDInsight Hive Task Azure HDInsight Pig Task Azure HDInsight Create Cluster Task Azure HDInsight Delete Cluster Task
??? Known tasks and to be organized to the above category	Execute SQL, Bulk Insert Task, Script Task, Script Component,