Datetime datatype null value?

[bellsports]

I want to load blank/null dates into a Microsoft SQL 2000 database. What does SQL recognize as a null value for datetime?

Thanks!

 

[balves]

NULL

as in INSERT table (field_dt) VALUES (NULL)

 

[bellsports]

I have tried using "null" as the value for my import file (I am updating the database using DTS) and the DTS does not like the "null". I have an import txt file, delimited by ";" with dates in it. Some dates do not have a value. I am having a problem loading this file due to the null values of some of the dates. On the export, I can convert a null value to an acceptable value for SQL but I am having trouble figuring out what it will take.

Any suggestions?

Thanks

 

[grahamm]

How about an empty field? e.g.

Apples;10/22/2001;...
Pears;;...

It's important that field is empty (no spaces) and that the column in your table allows nulls.

 

[tlbroadbent]

You'll have to modify the DTS transformation script. I use VB scripting so this sample will be a VB script sample.

Test the source column for each date in the file. If the date is empty or invalid store NULL in the destination column.

IF trim(DTSSource("Col006&quot)="" THEN
DTSDestination("dt_payment_pay&quot = NULL
ELSE
DTSDestination("dt_payment_pay&quot = DTSSource("Col006&quot
END IF Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.