Jeffrey: re: "..then the stored procedure will execute in the context of the SQL Server service account."  Thanks.  That is good to know.  I've been trying to follow the advice...

Jeffrey: Thank you for clarifying how I could change my SSIS package so that it could run via Agent every X minutes.  I understand what you are saying now.  It...

THIS IS AN INTERIM UPDATE: I wanted to wait until I had a final answer before posting back here, but a lot of time has gone by and I can't...

Jeffrey: Thanks for clarifying the process you are thinking of. There's some kind of disconnect here as I'm still not fully following you. That's OK though. We can let this...

re: "It seems this is a process that loads data into SQL Server from defined CSV files - which can be scheduled to run every xx minutes."

I don't  think I...

re: "However - this may not work because the action of right-clicking and executing the package in SSMS may not be using the user credentials that logged into SSMS, and...

Jeffrey:  Thanks for the reply and added information/explanation.

You asked why my user needs to run the job on demand.  It's a fair question.  Here's the situation:

In the past, when we...

Do you mean the following? : Copy the .csv files to the local hard drive...

Thanks for the clarification Thom!  I emailed my network administrators with your information and asked if they could look at the problem as a 'double hop' issue.  I will let...

Thanks for the reply Martin.  I appreciate you taking the time.

Some points to note:

1. I know what you are saying about creating a proxy.  I know how to do that...

Thanks for the reply Thom.  Sadly, it is the network administrator who asked me to post on this forum since he doesn't know what to do.

I had not heard of...

I enjoyed the article.  Fun read.

I do have a different take on one point.  Oftentimes when I face a thorny problem, I find it helpful to take a break.  While...

Thanks Jeff!  So fun to get to work with the RBAR guy.  🙂

*** FINAL ANSWER ***

Bottom Line:  A change of vCPUs from 4 to 8 fixed the hanging problem.

WHAT ABOUT RAM?

I tried to argue for 16 GB RAM not only to possibly...

Thanks Jeff! I really appreciate the support. When I think about how many *weeks* I have spent trying to figure this problem out (long before I posted here), I feel...