asked on

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"

chapmandew

make sure the account running sql agent has the same perms that your account does...ie, filesystem.

Samoin

ASKER

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.

ASKER CERTIFIED SOLUTION

Reza Rad

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Samoin

ASKER

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.

Thanks

Samoin

ASKER

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 Rad

Glad to help,
Regards,