I have a ,dtsx package stored in a folder and trying to move it from one to server to another. The SQL version is remaining the same it's just the OS version being updated.
I have setup the package to run as a SQL job from the File System as we don't have SSIs catalog or Db and this was the way it was running on the old server.
When I run the job I'm getting the below errors
Failed to complied scripts contained in the package. Open the package in SSIS Designer and resolve the compilation errors.
The directory is not empty (exception from HRESULT: 0X80070091
Access is denied (exception from HRESULT: 0X80070005)
The account running the package is the build in service accounts for SQL and I have added them to the administrator group on the server. The folder is empty so I am lost what else could be the problem