The transformation process usually occurs during the migration process, although some transformation may occur during the scrubbing process, while the data is in an intermediate database.
To move and transform data from one or more heterogeneous sources to a destination or multiple destinations
OLE DB data sources, ODBC data sources, and text files
OLE DB providers make data available by exposing standard COM interfaces that any programming language environment with COM support can use.