I am getting an error while loading data from Vertica to SSIS.

What is the Vertica server version? E.g. output of select version();
If you are able, and the server version is indeed 9.2.1 or later, edit the ODBC data source to include the parameter TLSRenegotiationLimit=0

Sorry to resurrect an Old post, but I am having the same issue with my ODBC connection. I am using the 10.0.x ODBC drivers
But my Vertica service is of version " Vertica Analytic Database v9.0.1-8 "

I get the same error as OP everytime I try to read data more than 2 to 3 million. Actually I am not sure if the volume is the issue! On teh ODBC DSN setting, I dont see option to set - TLSRenegotiationLimit

But my concern is, if the DB version is 9.0.x, will this setting still be applicable? How do I overcome it?

Sorry to resurrect an Old post, but I am having the same issue with my ODBC connection. I am using the 10.0.x ODBC drivers
But my Vertica service is of version " Vertica Analytic Database v9.0.1-8 "

I get the same error as OP everytime I try to read data more than 2 to 3 million. Actually I am not sure if the volume is the issue! On teh ODBC DSN setting, I dont see option to set - TLSRenegotiationLimit

But my concern is, if the DB version is 9.0.x, will this setting still be applicable? How do I overcome it?

Hi,

Can you confirm the SSIS environment that you have. Is it SSIS 2016 or SSIS 2019 ? We need to get its details in order to proceed further.

Thanks/Vivek

Isn't it the same issue as https://forum.vertica.com/discussion/242511/consider-setting-the-configuration-parameter-tlsrenegotiationlimit-to-zero ? If so check accepted answer.

The link : https://forum.vertica.com/discussion/242511/consider-setting-the-configuration-parameter-tlsrenegotiationlimit-to-zero is related to Power BI issue but here its in context with SSIS, where we need to know the SSIS environment version in order to proceed forward

Regards/Vivek