Here is a Guide on SSIS
Integration Services Tasks
| Service Type | Service Name | Explanation |
|---|---|---|
| Data Flow Task | Data Flow Task | * Extract data from a variety of sources, apply column-level transformations, and load data into a database |
| Data Preparation Tasks | * FTP Task * Hadoop File System Task * File System Task | * Copy files and directories from local file systems, FTP sites, or the internet. * Apply operations to XML documents, and profile data for cleansing. |
| Workflow Tasks | * Execute Package Task * Send Mail Task | * Communicate with other processes to run packages or programs * Send email messages, read WMI data, and watch for WMI events |
| SQL Server Tasks | * Execute SQL Task * Execute T-SQL Statement Task | * Access, copy, insert, delete and modify SQL Server objects and data |
| Scripting Tasks | * Extend package functionality by using custom-written scripts | |
| Analysis Services Tasks | * Create, modify, delete, and process Analysis Services objects | |
| Maintenance Tasks | * Rebuild Index Task * Back Up Database Task | * Performa administrative functions such as backup up SQL Server databases * Rebuild and reorganize indexes and run SQL Server Agent jobs |
| Custom Tasks | * Written in a programming language, such as Visual Basic or C# |
