Once Appreciate your valuable information to pin point the issue and as well as for resolution.
Oracle connection - we normally received TNS file and it has Oracle login info.
We have Installed the Sql Server on SSIS server and also configured SSISDB.
When you say running package from my work station, I don't get it that. (Sorry if i misunderstood)
When you open the Server connection through SSMS and in Sql server Agent has different owner then how it using my local work station info?
When i see the connection, it shows Kerberos not NTLM.
I don't see any SPN related error in my any sql server log.
When Package runs from Server A using Sql Agent job and connect to Server B - i have user having SysAdmin role and i also tried to use the same user assigning the proper permissions.
I have Sql Agent job setup on same SSIS server where it's executing the package (Server A) and connecting to insert the data into SERVER - B