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

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 (AT) discussions (DOT) microsoft.com> wrote

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

Thanks
--
TS


"Allan Mitchell" wrote:

The date was repeated in the same column on different rows exactly the same
format?

You can test to see if the values in that column fall between the range that
SQL Server will accept and if not either enter a default or a null.



--



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 (AT) discussions (DOT) microsoft.com> wrote