Converting text to table with DTS

I am using DTS to import text to a table. This mostly works except for the 'DateTime' datatype where I always run into either 'Arithmetic overflow' or 'Unable to convert varchar to DateTime format.' I can convert same data without incident in Access.

Has anyone run into this problem?Import the problem dates into a VARCHAR(30) column using DTS. Then mangle them at will using the SQL functions to make them easier to digest!

-PatP|||I'm kind of new to SQL...do you mean using functions like CAST and CONVERT in custom DTS packages?|||whats the format of date in the text file? use IsDate() function in the transformation ActiveX to check for validity of date
-Rohit|||Import the problem dates into a VARCHAR(30) column using DTS. Then mangle them at will using the SQL functions to make them easier to digest!

-PatP

Import everything in to an existing tables as varchar...the perform your audits...

and learn bcp......

Is the file fixed width or delimited?

Mangle...lol..