Devart Forums

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?

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