Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DTS Import/Export Wizard

0 views
Skip to first unread message

João Guerra

unread,
May 16, 2003, 4:45:29 AM5/16/03
to
Hi,

I'm trying to import a MS Access database using the DTS Import/Export Wizard
but in one of the tables i get this error:
-----------
Error at destination row number 806: errors encountered so far in this task
1
Insert error column 28 ('birthdate', DBTYPE_DBTIMESTAMP), status 6: Data
overflow
Invalid character value for cast specification
------------
the type of the field is date/time
I've already tried to change the field type from smalldate to datetime,
strangely it only reports the error at row 806 and i checked the data and
there is nothing differen in this record from the previous 805.

Thank you,

João Guerra


Evan Kontos

unread,
May 16, 2003, 7:47:08 PM5/16/03
to
I have a very similar error except my source field is small date. Any help
would be wonderful.

"João Guerra" <joaog...@cidef.org> wrote in message
news:10530748...@rhun.esoterica.pt...

Evan Kontos

unread,
May 19, 2003, 8:33:47 PM5/19/03
to
Is there anyone going to answer this question?

"João Guerra" <joaog...@cidef.org> wrote in message
news:10530748...@rhun.esoterica.pt...

Kalen Delaney

unread,
May 19, 2003, 8:54:03 PM5/19/03
to
Did you try asking it on the DTS newsgroup?

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


"Evan Kontos" <Eko...@comtekcadd.com> wrote in message
news:eJMt6dm...@TK2MSFTNGP10.phx.gbl...

0 new messages