SQLTeam.com | Weblogs | Forums

Case stmt in SSIS

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

Hello

Please provide some sample data?

hello

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

thanks

so is this some conditional in SSIS?

Hi,

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

Thanks
Pat

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

please see if this helps ...