December 1, 2008 at 4:53 am
DTS does not import date column from MS Excel.
Hello,
I have a DTS package that inserts NULL for the dates in column "VDate" in my SQL SERVER 2000 data table
instead of the actual dates.
If I copy the same date in another MS Excel column (BDate) it imports it correctly.
What could be the issue? Does the DTS get confused with the header row not being a date
and assumes for all others rows the wrong data type - then again, the same should hold
true for my column "Bdate" but there it works.
Any ideas?
December 2, 2008 at 9:30 am
I don't know if this is the answer, but the first thing I would check is the format in the data source. Excel's quite clever at showing things that look like dates as dates and, when data is taken from Excel to Excel, storing them as dates, but if the original data is read into Excel from a string source, until you've performed that copy across for all it looks like a date it may well be stored as a string. I think this is where DTS is having issues. You may need to format the data at source or continue to copy the data across before using DTS. (A small macro would do that for you in a tiny amount of time)
It is not a problem with the format of your heading.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply