Vertica & SSIS
We are using SSIS to import data into Vertica and are having a few intermittent issues. Wondering if anybody has experienced below problems or can recommend best practices when using Vertica/SSIS.
- The SSIS package occasionally fails with error "The AcquireConnection method call to the connection manager Vertica failed with error." We see no errors on Vertica side.
- We occasionally see wos_spill errors. In SSIS, inside of the data flow task, we are using a ODBC Destination component which does not allow us to use DIRECT hint.
The connection uses the Vertica driver which is version 7.02.01.00.