decimal rounding

[sds814]

I have a sql query that when I try to do a calculating and convert to decimal(9, 6), I get an error. However, when I convert to decimal(10, 6), the calculation works fine. The problem is that the field in the database is decimal(9, 6). When I try to do the data conversion in SSIS for that field to decimal(9, 6) I get the error: The conversion returned status value 6 and status text "Conversion failed because the data value overflowed the specified type."

Any ideas on how to resolve the problem? Thanks.