question

Noonies avatar image
Noonies asked

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?
ssisftp
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Noonies avatar image
Noonies answered
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!
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
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?
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
@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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.