SQL Job is showing the job ran successful but is not completing the move of files to FTP site
Hi, I have a package that creates a CSV file and moves the files to an FTP vendor site. The package works fine but when I create a job to run the SSIS package, the job shows that it successfully ran but the FTP task is not actually moving the files. I execute the package and the files move to FTP just fine. I'm not sure where in the job I may have something incorrectly working with FTP. I have deleted and recreated the job but still the same thing occurred. Any ideas on what could cause this?
In order to fix this I had to import the package with EncryptSensitiveDataWithPassword and I used the FTP password. When I re-added the package to the job and clicked OK the password prompted and I used the FTP password again. After that the job ran and processed the FTP connection. I followed the information found in:
http://go4answers.webhost4life.com/Example/sql-server-agent-job-not-retain-package-51690.aspx @Kev Thanks again for responding and helping me out!
So the difference between running a job and running the package manually is the account? The job runs under SQL Agent Service, whereas the package is executed as ?????????? Maybe there is a permissions issue?