Samoin
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"
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"
make sure the account running sql agent has the same perms that your account does...ie, filesystem.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi reza_rad,
I tried running the package with EncryptSensitiveWithPasswo rd but still it's giving the same issue. I would really appreciate if you could give me some detail steps.
Thanks
I tried running the package with EncryptSensitiveWithPasswo
Thanks
ASKER
I was able to resolve this in the following way, first I selected the ProtectionLevel to EncryptSensitiveWithPasswo rd 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
exec xp_cmdshell 'dtexec /De Passowrd /f "filepath"' and it worked
Glad to help,
Regards,
Regards,