Good to know!   Thanks Sue.

I tried the Credential then Proxy but there was no option on the Proxy to run transact-sql type jobs.  Plus I wanted to use a SQL login and didn't work...

Failures are set to quit job reporting failure.

I know super frustrating.  If I change the owner of the job, is there a reason why it won't use this account to run the actual transact-sql statement within the...

If there are permission issues, should I not see "permission denied on.." or "insert failed on.." etc?  There are no errors in the agent log or sql log.  It says...

https://www.sqlservercentral.com/Forums/1697723/Scheduled-Job-runs-successfully-but-table-does-not-update
https://stackoverflow.com/questions/34161158/sql-server-job-runs-successfully-but-doesnt-execute-packages
https://community.spiceworks.com/topic/91933-sql-server-job-activity-monitor-says-suceeded-but-jobs-did-not-ru
https://dba.stackexchange.com/questions/89587/update-code-works-in-manual-stored-procedure-but-not-when-run-as-sql-server-agen

These are all relatively the same.  I've also tried the stored procedure route but doesn't work either.  There are many more...

There is no error when running the job in SQL Agent that's the problem. It says it ran successfully yet no inserts were done.  If I copy and paste the...

I don't have a password parameter.  I'm passing the password by editing the datasource in SQL Agent and entering Password= after UserID= so the password is stored.  The debug was...

Here's what I'm not understanding.  I setup both of these SSIS package a few weeks ago and they both ran fine using debugging ie could see all the green checkboxes...

This has been working for a few weeks successfully so I don't understand why it would just stop working.  I used this https://www.mssqltips.com/sqlservertip/2874/loop-through-flat-files-in-sql-server-integration-services/ to create the integration which was working...

The package is deployed to a file and not the server.  The area it's failing on because of the error descriptions is the File System Task which takes the files...

When I run this package from within SQL Server Agent Jobs, I get "Description: An error occurred with the following error message: "Access to the path is denied."

Since...

I've recreated the package and am now at least getting some debugging info. I am testing this inside SSIS. I have typed in the SQL user ID and...

If I use the actual filename in the folder of the foreach loop, it still does not do anything. Even if I manually select one of the csv files in...

The debug no longer shows checkmarks either. Progress tab only shows:

Validation has started
Validation is completed
Start, 11:57:18 AM
Finished, 11:57:18 AM, Elapsed time: 00:00:00.141

WHy...