I seem to have an oddity in importing an Excel file via DTS using SQL
Server 2000.

All of the information imports just fine (including 3 date fields),
however on one particular date field, it errors and fails. The
following is the error log:

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data
Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (Microsoft Data Transformation Services (DTS) Data Pump
(8004202c): TransformCopy 'DTSTransformation__10' conversion error:
General conversion failure on column pair 1 (source column 'Birth
Date' (DBTYPE_DATE), destination column
'DateOfBirth' (DBTYPE_DBTIMESTAMP)).)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

The method I used was copy column, when that didn't work I wrote some
vbs in an activex script and it kept giving me errors on :

DTSDestination("DateOfBirth") = CDate(DTSSource("Birth Date"))

I checked the table and the column in question is the same as the
other datetime columns, there are no constraints. I attempted to use
copy column on a different date field in the table and it also failed.
When I tried using a different date field in the Excel file to the
DateOfBirth column, it succeeded. This leads me to believe that it's
something with the Excel file.


The data in the Excel file is normal, and all of the rows have a value
(none are null). I tried importing it as an Excel date (i.e. number of
days since 1/0/1900) via ActiveX vbs script and it would give me
errors on DateAdd(). I formatted the cells back to a date and tried it
again, still nothing. The data is setup in this column in the Excel
file in a M/d/yyyy format.

Anyone else have this problem or know how to solve it?

Thanks,
Sean

Did you try checking your date range? If its outside of SQL limits it
may fail..

Good luck..

On Apr 3, 9:57 am, Sean <ColdFusion... (AT) gmail (DOT) com> wrote:

Did you try checking your date range? If its outside of SQL limits it
may fail..

Good luck..

On Apr 3, 9:57 am, Sean <ColdFusion... (AT) gmail (DOT) com> wrote:

Did you try checking your date range? If its outside of SQL limits it
may fail..

Good luck..

On Apr 3, 9:57 am, Sean <ColdFusion... (AT) gmail (DOT) com> wrote:

Did you try checking your date range? If its outside of SQL limits it
may fail..

Good luck..

On Apr 3, 9:57 am, Sean <ColdFusion... (AT) gmail (DOT) com> wrote:

Did you try checking your date range? If its outside of SQL limits it
may fail..

Good luck..

On Apr 3, 9:57 am, Sean <ColdFusion... (AT) gmail (DOT) com> wrote:

Did you try checking your date range? If its outside of SQL limits it
may fail..

Good luck..

On Apr 3, 9:57 am, Sean <ColdFusion... (AT) gmail (DOT) com> wrote:

Did you try checking your date range? If its outside of SQL limits it
may fail..

Good luck..

On Apr 3, 9:57 am, Sean <ColdFusion... (AT) gmail (DOT) com> wrote:

Did you try checking your date range? If its outside of SQL limits it
may fail..

Good luck..

On Apr 3, 9:57 am, Sean <ColdFusion... (AT) gmail (DOT) com> wrote: