SSIS stands for SQL Server Integration Services. It's used for ETL process. This process itself is very relevant in datawarehousing discipline.

Holli lists a url, which you may find helpful.

Let me know if additional details are needed or not.
Regards,
Rajib Bahar