I have an SSIS package which is reading from an OData V3 service using the MS OData component for SQL Server 2012

Recently it has started randomly failing when acquiring the data e.g.

SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on Positions returned error code 0xC02090F5.  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.

The issue goes away after a few runs of the package.

Is there any documentation on the error codes; I'm presuming it complaining about the data or the metadata of the feed but without more information it's difficult to diagnose.

Regards

It looks like a network issue

Arthur

What's that based on - it fits with the behaviour but I'd like to know your reasoning.

Also is there a way of telling the OData component not to timeout or increase the timeout period?

There is none, you need to simply implement a retry in the event of inability to connect