Re: Import Error

Tech-Archive recommends: Speed Up your PC by fixing your registry

And the solution is? The Date was repeated in other rows with no problem!!
How can I resolve this?

Thanks
--
TS


"Allan Mitchell" wrote:

> Access' date range is different to that in SQL Server. You may be
> experiencing a date in Access that the destination in SQL Server cannot
> handle.
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "TS" <TS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:BCED7E0E-AA1F-4444-881B-C3A8E956BD85@xxxxxxxxxxxxxxxx
> > Using DTS, I imported a bunch of tables from Access to SQL. All the tables
> > have been transferred except but two that are giving me similar error
> > messages:
> > "Error Destination for Row number 58. Errors encountered so far in this
> > task:1. Insert Error, column 10 ('Block From Date', DBTYPE_DBTIMESTAMP),
> > status 6: Data Overflow. Invalid character value for cast specification".
> > I checked the row and column mentioned in the error message in the access
> > table and nothing looked suspicious. Please help!!
> >
> > Thanks
> > --
> > TS
>
>
>
.

Quantcast