SQL WIN2K
Access 97

When attempting DTS import receive the following error:
Error at Destination for Row 2838. Errors encountered so far in this
task:
1. INsert error, column 15 ('Visit Date',DBTYPE_DBTIMESTAMP), status
6: Data overflow.Invalid character value for cast specification.

I have also changed the date format of the column in Access from Long
Date to General Date and still receive the same error as above.

Thanks!

What do you have the SQL column datatype difned as..? SmallDateTime ..?

In SQL smalldatetime can only handle dates in the range :-

January 1, 1900, through June 6, 2079

What is the data of Column 15 at Row 2838..?
--
HTH
Ryan Waight, MCDBA, MCSE

"Rob" <the_ainbinders (AT) yahoo (DOT) com> wrote

Check for date ranges in Access that do not fit into the corresponding SQL
Server attribute limitations.

It may be of course that because of regional settings and the language of
the user that dates are being interpreted incirrectly ie MM/DD/YYYY instead
of DD/MM/YYYY



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Rob" <the_ainbinders (AT) yahoo (DOT) com> wrote

I am in the US dealing with a US db source.
In Access the date fields are set to Long Date and include the time.
In SQL the date fields are set to Date/Time.
All dates are since 01/01/1996 (mm/dd/yyyy).

Your help is appreciated as this is my first DTS import.

Rob


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

OK technically the dates look fine. Try plugging them into this article
though

Formatting Character Data into Datetime fields
(http://www.sqldts.com/default.aspx?249)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Rob" <the_ainbinders (AT) yahoo (DOT) com> wrote