your best option is not to use passwords at all.
change all your accounts to be MSA/GMSA accounts - GMSA more versatile as they can be used in more than...

That is a common "error" for must users of Power BI.
Although it asks you initially to sign on, you can close that window as you do not need to...

I think there may be more to this than just a simple insert.
Would it be possible to post here a actual explain plan of that insert (and if this...

yes - but why would you do it if there are better and easier ways to do it?
you can study the openxml model, and create the same...

adding to this . you do not even need to have a PK/FK and you can still join them.

Although FK with indexes will help in some cases from...

you may not be able to see them on ssms - but you can still execute them on the remote server.

you are obviously out of your league. I do advise you to ask for help from another DBA - or at least ask on the forums here before attempting to...

one other possible issue - if the instances were running under his ID, any backup location may also require permissions to be changed. 
This both for doing backups and to...

you are most likely missing the ACE driver on your server.
you can check these if you have sysadmin access to your instance executing exec sp_MSset_oledb_prop
the output will list...

Sorry again - just to clarify.

Is the issue doing a select on a SQL Server instance to retrieve data from a Oracle db?

or is it Oracle...

I consider the following construct a bit simpler and does not require the temp table
and output gets ordered by column_id as required
code based on the OP. Does have...