question

AnandDeshpande-3949 avatar image
0 Votes"
AnandDeshpande-3949 asked AnandDeshpande-3949 commented

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

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.

  2. 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.



sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered AnandDeshpande-3949 commented

Hi @AnandDeshpande-3949 ,

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.




· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AnandDeshpande-3949,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·

Hi @Monalv-msft,

Thanks for the suggestions. But i have already done the above changes but still not working.

Regards,
Anand

0 Votes 0 ·