When you use a ForEach container to loop through files in a folder, that container is expecting you to provide a "filespec".   A filespec is typically looks like this:
C:\Chase\Files\Daily\*.pgp

I'm not...

Users with update access to a production table?   Seriously?   Sounds more like your security model needs some serious work...   Never should a user have direct update access to a production...

Not sure why you want to do this, but it's not terribly difficult.   Here's the code:
create table #test (
    item varchar(100),
    [status] varchar(10),
    qty int
);
insert into #test...

Not sure what, exactly, you are trying to do.   If you establish a connection, then want to change your connection, then you'll have to re-instantiate your connection, so I'm doubtful...

My apologies for not posting back sooner, but here's what happened.   It just started working when I changed the date range provided as parameters.   I know for sure that once...