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
More About This Author
Array
Dyn365CE2023.02.02Moving Marketing Email, Journey, Events, etc. between environments – Dynamics 365 Marketing- Dyn365CE2023.02.01How to – Generate Long-Lived Page Access Token – Facebook
- Dyn365CE2023.01.31How to – Hide Approve / Reject Button in Approval Email in Power Automate Approval Workflow
- Dyn365CE2023.01.30Format property missing in Date Picker in custom page – Dataverse / PowerApps
