how to convert DBTYPE_STR to DBTYPE_TIMESTAMP 1

[Jeet2004]

I have a flat file and the data needs to be imported to a sql server. I did the dts package for it. Now the problem is out of 8 columns 3 are datetime whereas in excel everything is varchar.
So only for one column out of three(with datetime datatype) the job fails and give the error

Error Description: The number of failing rows exceeds the maximum specified. TransformCopy'DTSTransformation_5' conversion Error: Conversion invalid for datatypes on column pair 1(source column 'columnname'(DBTYPE_STR), destination column 'hire_date'(DBTYPE_DBTIMESTAMP))


Can anyone help me to get rid of this error
Thanks.
note: i tried using cdate in activex script still it doesnt work

Thanks

 

[DrSql]

You can use CAST or CONVERT.

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.