Int OverFlow in T-SQL

Experts,

The attached code gives me the following error:

The conversion of the varchar value '20000202008    ' overflowed an int column. Maximum integer value exceeded.


The two last rows of the table in the subquery have this type of larger value.  Tr_Trans_Number is an int, so it needs to compare to this column.  How can I make it work?

SELECT 
c.cu_acct_num,
ct.tr_Trans_number
FROM Customer_Transaction ct 
INNER JOIN Customer c 
ON ct.customer_ID= c.Customer_ID  
where ct.Tr_Trans_Number IN (SELECT Column1 FROM CCLCache.dbo.Comparison_Transaction_Accounts_EXCEL)

Select allOpen in new window