I'm trying to convert numeric dates on the AS400 to smalldatetime in
SQL. I'm able to customize to match format but when I save the
tranformation I get the following error. I don't know why they sould
let you customize the field if you cant convert. Any ideas?

"Error Description: TranformationDateTimeString('X') column pair 1
(source column 'Y'(DBTYPE_NUMERIC), destination column 'Z'
(DBTYPE_DBTIMESTAMP)): Cannot convert source datatype to datetime


*** Sent via Developersdex http://www.developersdex.com ***

If this is an import, try dumping it to a temp table then let the MS drivers do the job natively. What drivers are you using for this? client access?

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/