Hi all.

i need really your help with the next error. haven't idea what is the
problem.

----

DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error = -2147467259
(80004005)

Error string: DTSStep_DTSDataPumpTask_1: Error at Destination for Row
number 10919. Errors encountered so far in this task: 1.
Error source: DTS Data Pump
Help file:
Help context: 0

Error Detail Records:
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Insert error, column 18 ('FECHA_TERMINO',
DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Error source: Microsoft Data Transformation Services (DTS) Data Pump
Help file: sqldts80.hlp
Help context: 30702

Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Invalid character value for cast specification.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0

----------
can you tell me how i can determinate the corrup data in the source
database..Oracle 9i, if there is!.

thanx a lot. sorry for my bad english.

You are trying to insert into a column called 'FECHA_TERMINO' which is of
type DBTYPE_DBTIMESTAMP

The data you are trying to put in there is not valid. Something is blowing
it.


--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"New_DBA" <Luis.BautistaB (AT) gmail (DOT) com> wrote

thanx allan michell.

yes the column 'FECHA_TERMINO' is DATE... i found in the oracle table,
the row with the date '08/08/0202', i think that this break the SQL
server Date datatype column.

is this a right way? what ranges of dates are supported in sql server
date datatype.

Have a look here

http://doc.ddart.net/mssql/sql70/da-db_9.htm

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"New_DBA" <Luis.BautistaB (AT) gmail (DOT) com> wrote

thanks for your help allan. the link was very usefull to me..my problem
is solved.