View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
SSIS - Loading csv / Excel file removes Percentage Symbol
Source is Flat file
Now we want Destination is like this
Take Derived Column Transformation and Data Conversion Transformation to perform this task
By using derived column transformation we remove percentage symbol and by using data conversion transformation we convert the data types according oledb destination requirement.
In Derived column transformation we follow two ways to remove % symbol
1. By using Replace function
2. By using Substring function
By suing data conversion transformation convert data type as decimal.
Connect to OLEDB Destination we get required output
Other posts by Surendra