If you want help with actual T-SQL, please take the time to post your data in a format which we can all consume (with CREATE TABLE DDL and INSERT ......

I created an expression for Argument and that worked

Good idea, well done.

Can you try the same thing, but using a file path which does not contain spaces?

Is there no documentation for this API which explains how to use it?

DBCC TIMEWARP at its best.

Have you considered using SYNONYMs to perform the swaps, rather than sp_rename? Might be worth testing.

I'd also vote for the temp table option. Makes the code cleaner.

In my opinion, this does not sound like a robust development environment.

Your packages, together with projects and solutions, should be in source control. They should also be deployed to servers...

and don't ask why we want to choose the columns in sql - I suggested doing a "select as many as you need" and use a show/hide property in...

The OP did in their opening post.

That's twice in two days you've highlighted my inability to comprehend basic English, you scoundrel! 🙂

No one mentioned SSIS apart from you!

Run the package in debug mode so that you can inspect the variables for every trip round the loop. That should help you track down the issue.

Put the latest file name in a variable and then use that variable for your copy. Here is some code which does that, for any file in c:\temp:

            
February 6, 2020 at 8:36 pm
            
#3723762

            
            
                                                
        

Like this?

DECLARE @x VARCHAR(50) = '2020-02-06'

SELECT @x, REPLACE(RIGHT(@x,5),'-','/')

that is what my IT director keeps telling...