Skip to main content

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

  • August 18, 2015
  • 0 replies
  • 5 views

Chandra_Prakash
Forum|alt.badge.img+1

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