We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Does SSIS (SCD type 2) supports with vertica DB through OLEDB?? — Vertica Forum

Does SSIS (SCD type 2) supports with vertica DB through OLEDB??

Hi All,

I am using SSIS as ETL to populate my my SCD tables in vertica DB. I am able to build the OLEDB connection but seem like SSIS doesnt support VERTICA for SCD table type 2 via OLEDB.

Any help is much appreciated.

 

Vertica Version 7.1.2.x

SSIS - SQL server 2012 SP2

VS2012 upgrade 4

 

Regards,

CP

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file