Tasks are units of work and are present in SSIS packages. We have different TASK types depending on the type of work that NEEDS to be performed. Below are some of the most COMMONLY used tasks present in SSIS:

• Execute SQLTask: Used for executing SQL statements in relational databases.
• Data Flow Task: Used for reading data from one or more data sources, transforming them, and loading it to various destinations as required.
• Analysis Services Processing Task: Used for processing objects of the tabular model or SSAS (SQL Server Analysis Services) cubes.
• FTP Tasks: Used for sending and receiving files from FTP Servers to our local folders.
• Script Task: Used for writing .Net code as per requirements.
• Send Mail Task: Used for sending emails for notifying users regarding status, progress, or outcomes of tasks.
• Execute Package Task: Used for calling different packages of the same project. It also has the feature of passing the value of variables to the package.
• Execute Process Task: Used for running application as a whole or as a batch script. It can also be used for opening software like Microsoft Word, Excel, etc, and for unzipping compressed files.
• File System Task: Used for performing file system manipulations like move files, rename them, delete them, change the location, etc.
• Custom Task: If all the existing tasks do not MEET our requirements, then SSIS provides flexibility to create NEW custom tasks.