• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 636
  • Last Modified:

FTP Task in SSIS

Hi Experts,

I'm facing a particular issue, I have package that contains a FTP task. When I run the whole package in BIDS it works fine but when I schedule the task through SQL Server Agent Jobs it fails with following error

Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed.
Source: FTP Task Description: Unable to connect to FTP server using "FTP Connection Manager"
  • 3
  • 2
1 Solution
make sure the account running sql agent has the same perms that your account does...ie, filesystem.
SamoinAuthor Commented:
Hi chapmandew,

The permissions are same, in fact  i'm using proxy account  to schedule the job on the agent. Other thing that i noted was if I take the FTP task out of the package everything works fine.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

SamoinAuthor Commented:
Hi reza_rad,

I tried running the package with EncryptSensitiveWithPassword but still it's giving the same issue. I would really appreciate if you could give me some detail steps.

SamoinAuthor Commented:
I was able to resolve this in the following way, first I selected the ProtectionLevel to EncryptSensitiveWithPassword in package properties and then used the t-sql type in the step and ran the following command
exec xp_cmdshell 'dtexec /De Passowrd /f "filepath"' and it worked

Reza RadConsultant, TrainerCommented:
Glad to help,

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now