Hi,

I'm getting an error report ... specifically

Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code:
0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client"
Hresult: 0x80004005 Description: "Invalid character value for cast
specification".
An OLE DB record is available. Source: "Microsoft SQL Native Client"
Hresult: 0x80004005 Description: "Invalid character value for cast
specification".
(SQL Server Import and Export Wizard)

Error 0xc020901c: Data Flow Task: There was an error with input column
"TAXPOINT_DATE" (390) on input "Destination Input" (292). The column status
returned was: "Conversion failed because the data value overflowed the
specified type.".
(SQL Server Import and Export Wizard)

This happens after about 330,000 rows have been transferred... the source
tables consists of arouns 1.2 million.

The DTS Wizard recognises the data type as datetime... I'm using the
Easysoft ODBC IB7 Driver to do the transfer...

Managed to transfer entire table out to Access no problems using DTS,
thinking I could then transfer back in SQL Server, but same problem occurs
around same point??

What am I missing?? Is it the way the target database is set up ?

Any help would be great.

Thanks