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?
asked Jul 19, 2012 at 08:55 PM in Default
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!
answered Jul 30, 2012 at 10:49 PM
So the difference between running a job and running the package manually is the account?
Maybe there is a permissions issue?
answered Jul 19, 2012 at 09:06 PM
Kev Riley ♦♦