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.
User contributions licensed under CC BY-SA 3.0