Case stmt in SSIS

SSIS and Import/Export
1

Hi,

Need to write the following code for data migration but need help please!!
hgt_ft=CAST((left(hgt, 1) *12.00) as decimal(7,3))
and
hgt_in=(case ISNUMERIC (REPLACE( right(hgt, len(hgt)-2), '"', ''))
when 1 then CONVERT(decimal(7,3),REPLACE( right(hgt, len(hgt)-2), '"', ''))
else 0
end)

how to??

Thanks

2

Hello

Please provide some sample data?

3

hello

not it was given to me to create and do not have access to test the data either.

thanks

4

so is this some conditional in SSIS?

5

Hi,

yes, i think the data is coming in different format and need to convert to correct one.

Thanks
Pat

6

Thats the point we dont know all the data types coming.so pretty hard to help you with just code you have posted

7

please see if this helps ...