Data Flow Transformations in SSIS – Nishant Rana’s Weblog
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
- Dyn365CE30 April 2024Use Geolocation Settings for Location Tracking and Auditing – Dynamics 365 Field Service
- Dyn365CE29 April 2024Fix the trigger – Microsoft.OData.ODataException: A binary operator with incompatible types was detected. Found operand types ‘Edm.Guid’ and ‘Edm.String’ for operator kind ‘Equal’ (Power Automate / Dataverse)
- Dyn365CE23 April 2024Portal does not load and displays “Server Error” or shows “Getting set up.. This might take a while” message -Portal Startup Issue (PowerApps Portal)
- Dyn365CE22 April 2024Versioning and Drafts for Solution-based Cloud Flows – Power Automate