May 7, 2008 at 1:19 pm
I have an Access 2000 database where the copay amount is stored as a string and looks like $20.00
In my data flow, I have a derived column that takes out the $ by using Replace: (REPLACE(Copay, "$", "")).
I now need to change the result to a currency data type. I tried a second derive column transformation with (DT_CY)[CoPay] but that didn't work. Any ideas?
Note: Copay field in source may be null or blank.
JamesNT
May 7, 2008 at 2:00 pm
What error are you getting? It could be the blank values are causing the issue. Convert blanks to null before converting to currency.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 8, 2008 at 12:40 pm
I would expect this to work:
(DT_CY)(TRIM(REPLACE(Copay, "$", "")))
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply