There are following 10 transformations mostly used
Ø
Aggregate
Ø
Conditional split
Ø
Data conversion
Ø
Derived Column
Ø
Look Up
Ø
Merge
Ø
Merge Join
Ø
Multi cast
Ø
Sort
Ø
Union all
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Delay Validation Property is available on Task level, Connection Manager, Container and on Package level. By default the value of this pro... -
There are multiple ways to run the SSIS package. Refer my previous post where I explain the multiple ways to schedule our SSIS package. I... -
Suppose you have excel and in that excel we have a column that contains mixed data type (like number, date, string etc.). While we are try... -
The RecordSet destination does not save data to an external data source. Instead, the RecordSet destination saves data in memory in a Reco... -
The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way to join two data sources together. There ...
No comments:
Post a Comment
If you have any doubt, please let me know.