Page 1 of 1

Connector to connect SSIS with Vertica

Posted: Mon Aug 12, 2013 11:39 pm
by Ranjith.chowdary
Hello Everyone,

Do we have a connector which we can use to connect SSIS with Vertica?.

Also one more question,

Can my architecture look like SQL Server -- > SSIS --> Vertica using SSIS as a ETL tool. Am a newbie to both SQL Server and Vertica. Let me know if i have to rephrase my questions.

Thanks in Advance.

Re: Connector to connect SSIS with Vertica

Posted: Tue Aug 13, 2013 1:15 pm
by JimKnicely
Hi,

You can download the Vertica Windows Client package or the ado.net driver from here https://my.vertica.com/downloads. You can use either the ODBC driver (included in the package) or the ado.net driver to connect SSIS to Vertica.

Re: Connector to connect SSIS with Vertica

Posted: Tue Aug 13, 2013 5:22 pm
by Ranjith.chowdary
Thanks for the reply. I will try that out.