SSIS Package Runs Manually but Not from SQL Job

2

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

And then:

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.

sql-server
ssis
sql-job
asked on Stack Overflow Jun 21, 2019 by user3510083 • edited Jun 21, 2019 by Hadi

1 Answer

0

I faced similar issue and done the below one.

In SQL SERVER CONNECTION PROPERTY, try to set the 'NO COUNT' option to 'OFF' and see is that fix your issue?

enter image description here

answered on Stack Overflow Jun 21, 2019 by Sathiya Kumar

User contributions licensed under CC BY-SA 3.0