|
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?
(comments are locked)
|
|
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!
(comments are locked)
|
|
So the difference between running a job and running the package manually is the account? Maybe there is a permissions issue? Does the job, though it is looking at the package, need the FTP ConnectionString defined with username and password? or should it still be connecting using the FTP Connection Manager from within the package? I'm showing SSIS and SQL Agent having the same account.
Jul 19 '12 at 09:18 PM
Noonies
@Kev Riley - I found this article http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7797ef9e-4f0f-4386-8c2d-4c8cb8f588a4/ which is close to the issue I am having. I'm having our IT Admin check the firewall to see if that may be the issue. Thank you for your response and I will follow up to let you know if its permissions or firewall issue.
Jul 19 '12 at 10:36 PM
Noonies
(comments are locked)
|
