Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 823
  • Last Modified:

SSIS Derived Column help add decimal

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
rtay
Asked:
rtay
1 Solution
 
Sreedhar VengalaSr. Consultant - Business IntelligenceCommented:
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now