SSIS ODBC Source Fails When Deployed to SSISDB


The package runs fine in Visual Studio, but once it's deployed to the SSISDB, this source is returning the below error without any other error or context information. If I limit the number of rows in the source query to 25 rows or less, the package executes without error. Without a row limit, the full query pulls back 8k rows, so this isn't a large amount of data.

Notifications:Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Source Notifications 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.

I have tried changing to the 64bit odbc driver and still get this error. I have tried reducing the batch size and still get this error.

asked on Stack Overflow Feb 26, 2020 by sanJEP

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0