SSIS Package run from Visual Studio but fails from SQL Server Agent with the Error DTS_E_PRIMEOUTPUTFAILED

0

Last few days, SSIS Job is failing. Previously it was successfully executed. So I have executed the package using visual studio & it works. The source is SAP and used the Theobald component. SQL SERVER 2017

The following error is getting in SSMS

Load Agreement data 1:Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ZOH_AGGRM returned error code 0x80131505. 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.

Load Agreement data 1:Error: System.TimeoutException: The operation has timed out.
at Theobald.Extractors.Ohs.OhsExtractorThirdParty.Run(Action 1 processResult, CancellationToken cancellationToken)
at Theobald.Extractors.Common.ExtractorBase`1.Run(Action 1 processResult, LoggerBase logger, CancellationToken cancellationToken)
at Theobald.Extractors.Common.ExtractorBase`1.Run(Action 1 processResult, LoggerBase logger)
at XtractIS.XtractSourceOHS.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)

Please help me.

ssis
ssis-2012
ssis-2017
asked on Stack Overflow Apr 8, 2021 by Anand • edited Apr 13, 2021 by Muhammad Tariq

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0