I have created a SSIS package.
If I run it from Visual Studio, it works.
If I deploy it to the server and RDP to that server and run it from SSMS, it works.
If I add it to a job with a Proxy Account and run it from the job, it works.
It does not work and fail when I run it from SSMS that is on local desktop. Any idea why the local SSMS cannot run it while the SSMS on the server can run it?