SSIS has various data flow transformation components that make it easy to manipulate the source data before it can be sent to the destination for processing.
Below are some of the most frequently used one
For changing the data type of the source column.
Simply select the input column and then specify the data type for it.
For e.g., if our source has one of the date columns as a string, we can apply Data Conversion transformation to convert its data type to Date.
Can be used if we want to…
Continue Reading Nishant Rana’s Article on their blog
Data Flow Transformations in SSIS – Nishant Rana’s Weblog
Blog Syndicated with Nishant Rana’s Permission