Still having a problem. At about record 14334, I get the error message:
SQL Execution Error
Executed SQL Statement
SELECT CASE IsNumeric(AdNumber)
WHEN 1 THEN CAST(AdNumber AS Int)
ELSE 0
END AS AdNumber FROM TNDL
Error Source .NET SQLClient Data Provider
Error Message; SyntaxError converting the varChar
Value '. ' to a column of the data type int

Could it be that a period passes the IsNumeric test, but fails when it actually is converted to integer?

How could I handle this?