Newbie control file question

From: Sashi <smalladi_at_gmail.com>
Date: Tue, 1 Sep 2009 08:46:41 -0700 (PDT)
Message-ID: <883aac5e-e0b4-45ba-871d-140e7a4d5cfe_at_r27g2000vbn.googlegroups.com>



All, I'm trying to load data using a control file. Here's the sqlldr version:
SQL*Loader: Release 10.2.0.3.0 - Production on Tue Sep 1 11:43:14 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Here's a sample data line:
"941 -
Warren","06/08/09","00:08","9085635152","9733928015","4","54","002","NEWARK , NJ","NJ","Toll",".18","0000019619"

Here's my control file:

LOAD DATA
INFILE '/my/source/file.csv'
INTO TABLE dest_table
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS (
SWITCH_NAME,
CONNECT_DATE "MM/DD/YY",
CONNECT_TIME,
SRC_NUMBER,
DEST_NUMBER,
DUR_MM,
DUR_SS,
TRUNK,
LOCATION,
STATE,
CALL_TYPE,
COST,
EXP_CODE
)

It's being rejected thus:
Record 1: Rejected - Error on table CDR_TEMP_FEED, column CONNECT_DATE. How do I fix this?

TIA,
Sashi Received on Tue Sep 01 2009 - 10:46:41 CDT

Original text of this message