[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

FTP Task in SSIS

Posted on 2010-01-08
6
Medium Priority
?
633 Views
Last Modified: 2013-11-10
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"
0
Comment
Question by:Samoin
  • 3
  • 2
6 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 26214713
make sure the account running sql agent has the same perms that your account does...ie, filesystem.
0
 
LVL 1

Author Comment

by:Samoin
ID: 26214845
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.
0
 
LVL 30

Accepted Solution

by:
Reza Rad earned 1500 total points
ID: 26247991
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 1

Author Comment

by:Samoin
ID: 26285009
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
0
 
LVL 1

Author Closing Comment

by:Samoin
ID: 31675682
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

0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 26287555
Glad to help,
Regards,

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question