SSIS output error when there are no records on Data Flow Task

0

I'm querying records from an IBM DB2 database. If there are records, the data flow task runs fine, when there are no records I get this error:

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ODBC Source CENTRAL (ExtraLog) 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.

[ODBC Source CENTRAL (ExtraLog) [2]] Error: Open Database Connectivity (ODBC) error occurred. state: '07005'. Native Error Code: -501. [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0501 - Cursor SQL_CUR0A4463B0 not open.

Again, it only happens when I have no records. Any ideas on how to stop this error? Your help is greatly appreciated.

ssis
db2
dataflowtask
asked on Stack Overflow Aug 3, 2018 by Russtopher • edited Aug 3, 2018 by AB_87

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0