You have some data in that column that does not convert correctly. That's the overflow.

No matter what you think, this is a common error and a reason why you store numeric data in numeric data types. There is some value in your column which is not converting,