June 13, 2014 at 10:01 am
Can someone point me in the right direction with correcting the following connection mgr error?
Executed as user: HNETNT\SQLISDEV. s Details Load SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Claims Details Staging" (61) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (74). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2014-06-13 08:18:02.43 Code: 0xC0209017 Source: Claims Details Load Claims Details [1] Description: Setting the end of rowset for the buffer failed with error code 0xC0047020. End Error Error: 2014-06-13 08:18:02.43 Code: 0xC0047038 Source: Claims Details Load SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Claims Details" (1) returned error code 0xC0209017. 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. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:57:47 AM Finished: 8:23:07 AM Elapsed: 1520.62 seconds. The package execution failed. The step failed.
June 27, 2014 at 12:41 pm
This doesn't look like a connection error to me.
Is there a script component in the flow, or is your source a text file?
Is the source component turning red or the destination?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply