Solved

SSIS Derived Column help add decimal

Posted on 2014-03-04
1
581 Views
Last Modified: 2016-02-10
I need help converting a number in SSIS derived column.

The field is currently set as a string [wstr].

the number looks like this 5834

It needs to be 58.34

does someone know the ssis expression to add the decimal after the first two digits?
0
Comment
Question by:rtay
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
Sreedhar Vengala earned 500 total points
ID: 39905117
Use Derived Column Transformation.  Where 'numericvalue' is your input string.

(DT_DECIMAL,2)(SUBSTRING(numericvalue,1,LEN(numericvalue) - 2) + "." + RIGHT(numbericvalue,2))
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question