Tuesday, 10 April 2012

What is SSIS

Q: What is SSIS ?
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.