Missing Oracle Connection in Visual Studio 2022 for SSIS Projects - Faz Business

I am missing the Oracle Connection from an existing SSIS Project even though I am confident I have installed the tools required.

The markup from the connector is below:

<?xml version="1.0"?>
<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"
  DTS:ObjectName="OracleLive"
  DTS:DTSID="{2306227C-4C40-4164-A0F2-DE07D6728108}"
  DTS:CreationName="ORACLE">
  <DTS:ObjectData>
    <DTS:ConnectionManager>
      <OraConnectionString>SERVER=xxx.local:1521/LIVE;USERNAME=xxx;WINAUTH=0;</OraConnectionString>
      <OraPassword
        Sensitive="1"></OraPassword>
      <OraRetain>False</OraRetain>
      <OraInitialCatalog></OraInitialCatalog>
      <OraServerName></OraServerName>
      <OraUserName></OraUserName>
      <OraOracleHome></OraOracleHome>
      <OraOracleHome64></OraOracleHome64>
      <OraWinAuthentication>False</OraWinAuthentication>
      <OraEnableDetailedTracing>False</OraEnableDetailedTracing>
    </DTS:ConnectionManager>
  </DTS:ObjectData>
</DTS:ConnectionManager>

This question is specifically aimed at SSIS Tools on Visual Studio 2022. I have a SSIS DB project that works on another PC, and I am obviously missing a component, however I am convinced I have installed all the required components.

Please don’t answer if you know nothing about SSIS and Visual Studio 2022, this is nothing to do with the Oracle Database, this is related to a missing component within Visual Studio.

Leave a Reply Cancel reply