I get series of Errors when SSIS package (deployed in file system) Executed from SQL Job , but same package works fine if executed manually.
First Error :
Directing the row to the error output failed with error code 0x80070057.
Second Error :
SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (86) failed with error code 0xC0209022 while processing input "OLE DB Destination Input" (99). 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.
and then :
Setting the end of rowset for the buffer failed with error code 0xC0047020
SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on 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.
Not getting any clue what could be the issue.
Same package was working fine few days earlier.
Thanks in advance.
User contributions licensed under CC BY-SA 3.0