I am trying to import data from a text file into a SQL database. I have a date field in the source file in the format YYYYMMDD and the corresponding column in the destination SQL database is a date format.
In trying to do a straight DTS copy from source to destination, I encountered the following error. “ data type from source different ( string) from data type in destination (Date)”.
I understand that I would have to write an ActiveX/VB
Script to do the conversion from string in data source to date format in the destination source. My knowledge in this area is almost zero. I would be grateful if anybody could tell me how to go about this.