January 25, 2010 at 9:49 am
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)
January 26, 2010 at 4:04 am
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
January 26, 2010 at 4:19 am
yeah Ive set delayvalidation to true
January 26, 2010 at 4:37 am
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 ?
January 26, 2010 at 4:42 am
As I said "The joys of SSIS and FTP!!":-)
Glad you got it sorted
Paul
January 27, 2010 at 12:03 pm
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 http://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.
October 29, 2013 at 12:11 pm
Thank you! It worked for me after I set package protection level to "Rely on server storage and roles for access control".
--Irina
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply