I keep getting an error with DTS and can not figure this
out. All my date are valid dates...so I have no clue. Can
anyone help? This is the error:
Error at Destination for Row number 6052. Errors
encountered so far in
this task: 1.
Insert error, column 9 ('DATE_OF_FTES',
DBTYPE_DBTIMESTAMP) status 6: Data
overflow.
Invalid character value for cast specification.

what does the row look like and which column are you using the CAST on and
what is the definition of the target column ?
"Anita" <anonymous (AT) discussions (DOT) microsoft.com> wrote

The dates may be valid for your source but what about the SQL Server
destination? What is the source datasource? A lot of datasource have
different ranges of allowable dates so this can be a problem. Regional
settings can wreck an import as well. What doe the Source value look like?
Is the destination a DATETIME in SQL Server?

--

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


"Anita" <anonymous (AT) discussions (DOT) microsoft.com> wrote