This is not complex. Convert the XL date output to DT_DBDate and it will map to the SQL Server Date without a problem.