I need to be able to pass a NULL date from a DTS DDQ VBScript to a SQL 7.0 stored procedure.
In my script the DTSDestination() variable is a char 10 (as variant). In the database, the target field is Datetime. The stored procedure is set up to receive the variable as datetime = null.
When an empty date is sent it defaults to 01/01/1900. Instead of an empty date I need to send it a NULL date, but have been unable to learn how to do so.
Any help would be greatly appreciated.
Bob
Database Development Team