While SQL Server will properly convert a char(8) date like '20020310' in a set or insert, BCP won't. You must use a delimited date format for BCP and BULK...