Hello everyone,
I am using DTS to transform data from foxpro.when it meets the date of NULL,it fails and says"Insert Error , column 4( 'Coloumn_name ',DBTYPE_DBTIMESTAMP), Status 6 ata overflow ".
And then i try to open the DTS Transform Data task and do a preview of the data from the 'Source' side.The Null values are treated as "1899-12-30".
After reading something ,i try to write an ActiveX scripting Task to solve this problem using the function of "IsDate()",but it fails with exceptions.
Now I don't know what to do.could anyone give me some suggestion?Anything will be appreciated!ThankX in advance!

--
Message posted via http://www.sqlmonster.com

Steven,

Smalldatetime date range starts with 1/1/1900 and that is why you have
overflow. Either change 1899-12-30 to 1/1/1900 or record null if column is
nullable.

Ilya

"Steven Wong via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

',DBTYPE_DBTIMESTAMP), Status 6 ata overflow ".
exceptions.