July 5, 2012 at 3:44 pm
Following is the error i am getting
It loads only 9000 rows and fails.
I see Source Data Flow Task is in Red
and Destination Data Flow Task in Green
------------------------------------------------------
[PRDIFX [1]] Error: There was an error with output column "vulner" (169) on output "OLE DB Source Output" (11).
The column status returned was: "The value could not be converted because of a potential loss of data.".
[PRDIFX [1]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "vulner" (169)"
failed because error code 0xC0209072 occurred, and the error row disposition on "output column "vulner" (169)"
specifies failure on error.
An error occurred on the specified object of the specified component. There may be error messages posted before this
with more information about the failure.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "PRDIFX" (1)
returned error code 0xC0209029. The component returned a failure code when the pipeline engine called PrimeOutput().
The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
There may be error messages posted before this with more information about the failure.
Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded,
but the number of errors raised (3) reached the maximum allowed (1); resulting in failure.
This occurs when the number of errors reaches the number specified in MaximumErrorCount.
Change the MaximumErrorCount or fix the errors.
Please Help Me
July 5, 2012 at 6:36 pm
Could you please check the Data type and Length of the datatype used are same on Source and destination?
S.R.Kundur
July 6, 2012 at 1:11 pm
What version of Informix? If it's an older RS/6000 based "Online" version.....it would be easy to get my wife to give up chocolate than getting the data out via those old ODBC drivers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply