MS SQL Server DTS - Problem inserting date from text file in SQL Server table

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Problem inserting date from text file in SQL Server table

kennethgrice@yahoo.com

2005-09-26, 8:24 pm

I have formatted the date from my Lotus Notes view as:

YYYYMMDD

and saved this as a text file

When I use the DTS wizard I always get an error for this column. The
data type in the SQL Table is set to DateTime.

Should I format my dates another way? I did have them set up like:
04/12/2005

The error is basically saying that I am trying to put a text string
into a timestamp.

But I don't understand why it is saying timestamp when the SQL Server
column is set to DATETIME. Do I have to manually put in some code to
convert to date format in the transformations box.

Thanks in advance for any help.

Sponsored Links