Well if you have xp_cmdshell turned on downloading a file is straight forward as a powershell command.

What is the exact problem you're trying to solve?

https://xkcd.com/303/

My ETL is running.

But realistically mostly my day(usually weeks/months) is goal oriented not metric oriented.

So are major companies really going to be okay just eating a potential 30+% CPU performance drop on their servers?

It sounds like the performance impact on the average...

Well it doesn't look like you actually joined the temp table into the query anywhere, you're just using it in the join criteria.

Drill into the action completed step in the history, you'll like see some kind of error code in there.  One way to test it is to RDC into the server...

Well.... one easy issue to fix is that the IF clause is commented out.