Do you have any suggested approaches on how I could test the connection string in SSIS or test the source file?   So far, I have been unable to replicate the...

I looked at those and they don't seem to be related.  I already have an ACE.OLDB connection manager and an Excel 2007-2010 file.  I'm using Visual Studio 2015 with most...

So, that was helpful.  I am finding error messages from SSIS.  (Clearly, I need to revisit my SSIS package to get the custom failure emails to execute properly.)
Below is...

Yes, I'm using sp_start_job.    Correct.  I'm only telling the user in the UI that the job started successfully.   They then wait for an email to tell them whether it completes successfully...