If you're using a data transformation task, use an ActiveX Script transformation for this specific tranformation.

Assuming the destination field in the database is named "YourDecimalValue" and the data is in...