DROP TABLE IF EXISTS #temp;

CREATE TABLE #temp
(
  prodID INT,
  mktID NVARCHAR(255),
  rev DECIMAL,
  qty DECIMAL
);

INSERT #temp
(
 ...

If you deploy your packages to SSISDB, this problem goes away, because you can do all of your config work with SSISDB 'environments'.

You have provided a set of requirements, but not asked any questions. Do you need help with something?

Unstructured data does not really belong in SQL Server. What are you intending to use the data for once it's inside the database?

Here is that image inline:

Does object BCPLStudent_diff exist?

Can you also check the text of the script which you have posted? It seems to be all mixed up and will never run as it stands.

I believe that you have over-complicated things. There is no need to split the logic into two paths.

Have a single path to your script task. The script task...

This is an interesting thread and I appreciate your well-thought-out comments, which have certainly made me think.

There is one part of your response which I'd like to take...