Derived columns using ssis 2008
Currently it looks like 0015000, this should be .15000
My expression in the Derived Column Tramsformation editor is
(DT_DECIMAL,7)(TRIM([SUB ACCT RATE]))
Results comes back as 15000 and not .15000
What i'm I doing wrong?
Pulling my hair out, thanks in advance.
My expression in the Derived Column Tramsformation editor is
(DT_DECIMAL,7)(TRIM([SUB ACCT RATE]))
Results comes back as 15000 and not .15000
What i'm I doing wrong?
Pulling my hair out, thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Divide by 10000000 instead of 100000.
ASKER
Currently it looks like 0015000, this should be .0015000
My expression in the Derived Column Tramsformation editor is
(DT_DECIMAL,7)(TRIM([SUB ACCT RATE]/100000))
Results comes back as .15000 and not .0015000