Business Intelligence Blogs

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 Delimeter

  • 15 April 2013
  • Author: Surendra
  • Number of views: 9985

SSIS - Loading csv / Excel file removes Percentage Symbol

Step 1:

Source is Flat file


Now we want Destination is like this


Step 2:

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.



Step 3:

In Derived column transformation we follow two ways to remove % symbol

1. By using Replace function

2. By using Substring function




Step 4:

 By suing data conversion transformation convert data type as decimal.



Step 5:

Connect to OLEDB Destination we get required output




Rate this article:
No rating


Other posts by Surendra

Please login or register to post comments.