DTS Import ( Date string to Date field)

gfowajuh · September 29th, 2003, 05:53 AM

Dear All

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.

Thanks
George

Deepesh_Jain · September 30th, 2003, 06:28 AM

Hi
Try to use Format function
Format(yourString,format of date in your table)
eg.
datestring="20030930"
fieldname=format(datestring,"MM/DD/YY")

Bye.

Quote:

quote:Originally posted by gfowajuh
Dear All

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.

Thanks
George

Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team