I'm having troubles importing date fields from a csv.
I've tried a variety of ways, but to no avail. I keep
receiving errors to the effect of:

Number rows failing exceeds the max specified.
TransformCopy 'DTSTransformatoin_4' conversion error:
Conversion invalid for datatypes on column pair 1 (source
column 'Col004'(DBTYPE_STR), destination
column 'move_out_date' (DBTYPE_DBTIMESTAMP)).

When I leave the date fields in the csv blank, it has no
problem entering all of the rest of the fields and
leaving the date fields as NULL. I'm a NewB to DTS and
I've tried a variety of different ways of storing the
datetime in the csv. Such as:

'2003-04-31','2003-08-13'
or
"2003-04-31","2003-08-13"
or
2003-04-31,2003-08-13

and none have worked. Can someone point me in a
direction so I can get this fixed? Thank you.

Have a look at this

Formatting Character Data into Datetime fields
http://www.sqldts.com/default.aspx?6,103,249,0,1

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Jeff Borden" <jeff_borden (AT) hotmail (DOT) com> wrote