Don,
Exactly as Charles said, you want to round the number to get rid of decimals. The integer data type is constrained to only store whole numbers.
Just to demonstrate in SSMS: This won't work...
SELECT CAST( '123.45' AS INT)
But this will work:
SELECT CAST( ROUND('123.45',0) AS INT)