SQL Server 2000 DTS datetime
Posted on 2003-02-19
I wish to load the following data into a table using DTS.
162,Data Removed,Nov 21 2002 11:04:13:030AM
The table consists of three fields of type (int,varchar(50), datetime).
If I change the date time to 11:04:13AM DTS loads the record. If I leave the time as it is I get the following error message :-
ActiveX Scripting Transform AxScriptXform encountered an invalid data value for update destination column.
Why will DTS and vbscript not recognise the full time stamp.
All suggestions welcome