Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

FTP Connection problem Expand / Collapse
Author
Message
Posted Monday, January 25, 2010 9:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 3:17 AM
Points: 133, Visits: 244
Ive spent the last few weeks developing an SSIS package that downloads a .zip file from an ftp server, unzips it and copies data from the unzipped access files to a sql server database. Its been working ok until I started developing hardware problems with the disk drive. Our support department gave me a replacement machine today, so Ive set the whole thing up and tried to run it again (Its scheduled to run inside a job)

Now for no reason I can fathom, it keeps failing on the FTP connection.

Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed . End Error Error: 2010-01-25 16:27:02.55 Code: 0xC002918F Source: FTP Task FTP Task Description: Unable to connect to FTP server using "FTP Connection Manager".

Im using a config file with protectionlevel set as 'DontSaveSensitive' and putting the ftp connection details inside the config file.
This has worked practically from day 1 of my development, nothing has changed, the ftp details are the same, yet it just wont connect anymore. Ive tested the connection through the dev envrionment (Visual Studio 2005), that checks out ok, so the problem isnt with the ftp server


this is the error in the SSIS log file

OnError,20739,NT AUTHORITY\SYSTEM,FTP Task,{ECE20D1F-C203-4BA2-8177-C1CFB7574DBE},{68445C0C-5DC1-421B-B09D-B793A05DB05F},25/01/2010 16:27:02,25/01/2010 16:27:02,-1073573489,0x,Unable to connect to FTP server using "FTP Connection Manager".

OnTaskFailed,PSLW20739,NT AUTHORITY\SYSTEM,FTP Task,{ECE20D1F-C203-4BA2-8177-C1CFB7574DBE},{68445C0C-5DC1-421B-B09D-B793A05DB05F},25/01/2010 16:27:02,25/01/2010 16:27:02,0,0x,(null)
Post #853112
Posted Tuesday, January 26, 2010 4:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 2:37 PM
Points: 33, Visits: 270
Hi,

The joys of SSIS and FTP!!

I do something similar, but my Package Protection level is EncryptSensitiveWithPassword. The password is passed in at sqlagent job run time.

Furthermore DelayValidation is set to TRUE

Paul
Post #853498
Posted Tuesday, January 26, 2010 4:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 3:17 AM
Points: 133, Visits: 244
yeah Ive set delayvalidation to true
Post #853509
Posted Tuesday, January 26, 2010 4:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 3:17 AM
Points: 133, Visits: 244
ok, figure this one out if you can. In desperation I completely removed the package from sql server and reinstalled it, now it works ! wtf ?
Post #853514
Posted Tuesday, January 26, 2010 4:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 2:37 PM
Points: 33, Visits: 270
As I said "The joys of SSIS and FTP!!"

Glad you got it sorted

Paul
Post #853517
Posted Wednesday, January 27, 2010 12:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 20, 2010 7:30 PM
Points: 4, Visits: 11
Hi,

Sorting out FTP problems is not as hard as you might think. I do agree with you on the un descriptiveness of SSIS errors though.

The 1st problem to check is port 21, a so called "FTP" port. To make sure that the port is OK, run ftp.exe from the command line and simulate the same operation that you were trying to achieve from SSIS. If that one fails, your problem is lying around firewall/permissions/restrictions.

The 2nd problem is FTP credentials or to be exact how they saved/retrieved. The rule of thumb in that case is to rely on SQL Server, i.e. to use "Rely on server storage and roles for access control" package protection level. This approach should remove all FTP credentials problems altogether (excluding mistypos of course).

My general advice to you is start small. Trying to put all the pieces together right away in SSIS is a recipe for disaster unless you're well experienced "decryptor" of SSIS errors.

Good luck,
Steve Rezhener.
Post #854633
Posted Tuesday, October 29, 2013 12:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 9:15 AM
Points: 6, Visits: 151
Thank you! It worked for me after I set package protection level to "Rely on server storage and roles for access control".
--Irina
Post #1509515
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse