SalesForce ODBC - SSIS PrimeOutput errors

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
rdsimpson
Posts: 1
Joined: Tue 14 May 2019 17:12

SalesForce ODBC - SSIS PrimeOutput errors

Post by rdsimpson » Tue 14 May 2019 17:22

I am trying to create an SSIS package to bring in and transform a rather large object from our salesforce instance. Whenever I try to use the SQL Command function for the ODBC source in order to limit the amount of data pulled in prior to transformation, the package errors out. The error I receive is "The PrimeOutput method on ODBC 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."

Switching the ODBC Source method to "Table" and selecting the specific table allows the package to run, but due to the size of the table, it takes 5-8 minutes to run. Has anyone else run into anything like this or have any ideas as to how to get this working?

MaximG
Devart Team
Posts: 1428
Joined: Mon 06 Jul 2015 11:34

Re: SalesForce ODBC - SSIS PrimeOutput errors

Post by MaximG » Fri 17 May 2019 15:21

We haven’t received any reports about that issue yet. We’ll investigate it and let you know about the findings.

Post Reply