SSIS is an ETL tool (Extract , Transform , Load) Which is very much needed for Data warehousing applications. SSIS is also used to perform the operation like loading data based on the need , performing different transformations on the data like doing calculations (Sum, Average, etc.) and to define workflow of the process flow and perform some tasks on the day to day activities.