July 27, 2012 at 3:55 pm
[PRODUCTION [1]] Error: There was an error with output column "vdescending"
(2273) 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.".
[PRODUCTION [1]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
The "output column "vdescending" (2273)" failed because error code 0xC0209072 occurred,
and the error row disposition on "output column "vdescending" (2273)" 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 "PRODUCTION" (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.
Hi these are the errors i am getting trying to load data from informix, the package initiaites well and fails after one loading 9400 rows.
Things I have done here to:
--- Changeed destination size to double from source, both datatypes are 'char'
--- Even changed dest table datatype to varchar, thinking i might help
---Created the other destination table while creating the package(thought it will select all data types that it needs to run properly)
---Set AlwaysUseDefaultPage Code to true
Any Kind of help is much appreciated thanks experts
July 28, 2012 at 1:24 am
try the data viewers to analyse the nature of data , if it's the conversion issue you may have corrupted data.
-- you can put the logging events for the task , this gives a better picture ;
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
July 30, 2012 at 12:47 am
Which datatype is used in the dataflow?
Go to the advanced editor of the source component and check the output columns.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply