Data flow in SSIS 2012 or 2008 Integration Services
Sources extract data from data stores such as tables and views in relational databases, files and Analysis Services databases.
Destinations load data into data stores or create in-memory datasets.
Transformations make modifications to the data as it is moved between a data source and a data destination.
The types of transformations that are available include: