"New_DBA" <Luis.BautistaB@gmail.com> wrote in message
news:1146246166.514960.325480@v46g2000cwv.googlegroups.com...
> 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. :)
>

"New_DBA" <Luis.BautistaB@gmail.com> wrote in message
news:1146251964.802492.304070@j33g2000cwa.googlegroups.com...
> 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.
>