Does SSIS (SCD type 2) supports with vertica DB through OLEDB??
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