SQL Job is showing the job ran successful but is not completing the move of files to FTP site

Question

question

Noonies asked Jul 19, '12

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?

ssis ftp

10 |1200

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

Answer 1 · 2012-07-30T22:49:26Z

Noonies answered Jul 30, '12

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

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

Answer 2 · 2012-07-19T21:06:41Z

Kev Riley answered Jul 19, '12

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

10 |1200

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

Noonies commented · Jul 19, 2012 at 09:18 PM

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 ·

Noonies commented · Jul 19, 2012 at 10:36 PM

@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 ·

question