MicrosoftZoe_Luo my issue is with the connection itself. As detailed elsewhere in this thread, our connection uses project-level variables in order to define the connection.
I've added the code for the connection below, while redacting the DTSID, as well as the server name and user name being used as login credentials. As mentioned, the exception from HRESULT: 0xC0011001 error persists.
Thanks in advance for any assistance you can offer.
<?xml version="1.0"?>
<DTS:ConnectionManager xmlns:DTS="http://www.microsoft.com/SqlServer/Dts"
DTS:ObjectName="MDM Destination-Oracle"
DTS:DTSID="{xxxxxxxx-3832-412F-A2BE-D7EF1AA2FE9A}"
DTS:CreationName="MSORA">
<DTS:PropertyExpression
DTS:Name="Password">@[$Project::mdm_password]</DTS:PropertyExpression>
<DTS:PropertyExpression
DTS:Name="ServerName">@[$Project::mdm_server]</DTS:PropertyExpression>
<DTS:PropertyExpression
DTS:Name="UserName">@[$Project::mdm_username]</DTS:PropertyExpression>
<DTS:ObjectData>
<OracleXMLPackage>
<OraConnectionString>SERVER=[ServerName] ;USERNAME=[UserName];ORACLEHOME=;ORACLEHOME64=;WINAUTH=0</OraConnectionString>
<OraRetain>False</OraRetain>
<OraInitialCatalog></OraInitialCatalog>
<OraServerName>SemarchyDEV</OraServerName>
<OraUserName>SEMARCHY_MDM</OraUserName>
<OraOracleHome></OraOracleHome>
<OraOracleHome64></OraOracleHome64>
<OraWinAuthentication>False</OraWinAuthentication>
<OraEnableDetailedTracing>False</OraEnableDetailedTracing>
<OraPassword
Sensitive="1"></OraPassword>
</OracleXMLPackage>
</DTS:ObjectData>
</DTS:ConnectionManager>
