x

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?
more ▼

asked Jul 19, 2012 at 08:55 PM in Default

Noonies gravatar image

Noonies
1.2k 60 64 65

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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!
more ▼

answered Jul 30, 2012 at 10:49 PM

Noonies gravatar image

Noonies
1.2k 60 64 65

(comments are locked)
10|1200 characters needed characters left

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?
more ▼

answered Jul 19, 2012 at 09:06 PM

Kev Riley gravatar image

Kev Riley ♦♦
54.3k 47 49 76

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, 2012 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, 2012 at 10:36 PM Noonies
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x946
x7

asked: Jul 19, 2012 at 08:55 PM

Seen: 1211 times

Last Updated: Jul 30, 2012 at 10:49 PM