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

Anand Deshpande 1 Reputation point
2021-04-08T11:01:08.36+00:00

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

  1. 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.
    1. Load Agreement data 1:Error: System.TimeoutException: The operation has timed out.
      at Theobald.Extractors.Ohs.OhsExtractorThirdParty.Run(Action1 processResult, CancellationToken cancellationToken) at Theobald.Extractors.Common.ExtractorBase1.Run(Action1 processResult, LoggerBase logger, CancellationToken cancellationToken) at Theobald.Extractors.Common.ExtractorBase1.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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,891 Reputation points
    2021-04-09T09:29:41.553+00:00

    Hi @Anand Deshpande ,

    1.Could you please share the screenshots of your components in SSIS package?

    2.Please check the Run64Runtime in SSIS package and then set it properly in job.
    86225-run64bitruntime.png

    3.Please set DelayValidation as True and ValidateExternalMetadata as False.
    86255-delayvalidation.png

    86256-validateexternalmetadata.png

    Best regards,
    Mona

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.