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: 7265
  • 0 Comments

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

 

 

 

Print
Tags:
Rate this article:
No rating

SurendraSurendra

Other posts by Surendra

Please login or register to post comments.