Sql Server Mgt Studio - Error DTS_E_PRIMEOUTPUTFAILED


When I run my package in Visual Studio to debug it runs without errors, however when I deploy it and run it in SSMS its throwing the following errors.

Person_View Data Flow: Error:

SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. the primeoutput method on Person_View source returned error code 0x80004005. 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 error that appeared before is:

Person_View data flow: Error: Database connectivity (ODBC) error occurred. state: ‘HY001’. Native Error Code: 0 [oracle][ODBC] memory allocation error.

If anyone could help me with these errors it would be greatly appreciated I have read that it could be too much data being passed at once but I don't know how to resolve this.

asked on Stack Overflow Oct 28, 2019 by Paula • edited Oct 28, 2019 by Dale K

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0