April 7, 2011 at 11:23 am
HI all,
i'm building a SSIS package to import data from Oracle 8 to sql 2005.
I'm importing about 800000 records but one of them cause tha package to fail because the Date conversion fails and the SSIS end with error giving me this error in process tab:
[OLE DB Destination [2738]] Error: There was an error with input column "DATA_ARRIVO_ORDINE" (2879) on input "OLE DB Destination Input" (2751). The column status returned was: "Conversion failed because the data value overflowed the specified type.".
The data flow is: OLE DB Source > Lookup > SPlit > Ole DB destination OR Ole DB command based on the Split results.
The package has been developed following this very good Andy Leonard article:
http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspx
It is possible to isolate the row that generates the error?
I should take some other approach to avoid the package fails?
Every support is welcome
April 8, 2011 at 12:04 am
Are you able to run a query in Oracle to get the min and max dates for that column? We had similar issues where SQL server can not store the same range of dates as Oracle and had to create a view in Oracle to filter out only 'valid' dates and use that as our source rather than the table.
April 8, 2011 at 12:25 pm
Good response.
I get a try abou ur suggestions and I've isolated the row which fails my package.
To give u all information: there was some records in Oracle that had date like 0008/02/13 and with MIN oracle function I isolated that (SQL Datetime data type valide date starts 1/1/1753 00.00.00.000).
THanks for ur support
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply