• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 849
  • 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?
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))
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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