Vertica Data Provider missing in Visual Studio 2022

Deepali Pareek 0 Reputation points
2024-06-28T19:25:55.3766667+00:00

On my new windows laptop I am trying to set up SSDT for SSIS packages. Earlier I was working on VS Enterprise 2017 version which I connected with Vertica using .Net Providers connection like this - image

but the 2022 version doesn't seem to have that option. I am using the SSDT 2022 now and also checked Vertica driver. The .Net Providers for OleDb has Vertica as an option but not .Net Providers
User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 104.8K Reputation points MVP
    2024-06-28T21:03:00.9233333+00:00

    I've never heard of Vertica before, but my gut reaction is that this is nothing that comes with Visual Studio, but the reason you have in VS2017 is because you installed it.

    For how to install it in VS2022, you may get better help in the Vertica forums, which appears to be at https://forum.vertica.com/.

    1 person found this answer helpful.
    0 comments
  2. ZoeHui-MSFT 34,756 Reputation points
    2024-07-01T08:28:15.01+00:00

    Hi @Deepali Pareek,

    It seems that Vertica Data only support VS2019 and earlier as said in Vertica Datan side.

    User's image

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments