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#