Not able to send file Using FTP in SSIS 2005
I am using SSIS 2005 I am trying to send file to ftp server using FTP task in SSIS but i am getting following error. Error Message-:An error occurred in the requested FTP operation. Detailed Description-:550 /FileName.txt: Access is denied. RemotefilePath is / I need a advice. Thanks in advance.
June 16th, 2010 8:23pm

This is probably access issue. This error is coming while you are working with BIDS? I would like to suggest you to try with the script task for the same. Please check the Matthew's thread.. its perfect. Let us TRY this | http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
June 16th, 2010 11:06pm

Chances are you do not have permission to create a file on the FTP site. Have you tried to transfer the file manually? If you get the same error, it's not an SSIS problem.
June 16th, 2010 11:37pm

Yes I have tried creating a file on FTP site manually and i could create it. I have copied text file manually on ftp site and i could copy that file. What can be the problem. Please suggest
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2010 6:09am

Hi ETL VS ELTL Yes i faced this issues while working with BIDS. I am using FTP task from SSIS 2005 to send the file on FTP Server. Thanks for Mathews thread link. I will try it Thanks
June 17th, 2010 6:21am

Hi All I am still getting this error. can anyone help me regarding this. I am sending a file on FTP server using FTP task in SSIS 2005 but i am getting this error. I am working with BIDS. Error-:[FTP Task] Error: Unable to send files using "FTP Connection Manager". Description-: [Connection manager "FTP Connection Manager"] Error: An error occurred in the requested FTP operation. Detailed error description: 200 Type set to A. 200 PORT command successful. 550 /Sameer/TestFile.txt: Access is denied. . When i set isTransferAscii to false then it give error message like [FTP Task] Error: Unable to send files using "FTP Connection Manager". Description-: [Connection manager "FTP Connection Manager"] Error: An error occurred in the requested FTP operation. Detailed error description: 200 Type set to I. 200 PORT command successful. 550 /Sameer/TestFile.txt: Access is denied. . Please advice. Thanks,
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2010 9:58am

Means you doesn't have access to the ftp folder (In ur case root folder "/") '200 Type set to I' means that the client requested binary mode transfer and that the server acknowledged this request
June 17th, 2010 10:50am

Thanks Manikandan S. Thanks for the help. I will ask for the access to root folder.
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2010 1:50pm

Does the file you're attempting to transfer with SSIS already exist? You may have permission to create a new file but not to replace an existing file.
June 17th, 2010 5:38pm

Thanks Wm Gann No the file is not exist....I am attempting to upload it...I have heard that we need to do some configurations settings with SSIS to make this work. Do we need to do any configurations settings with SSIS to make file transfer work using FTP in SSIS 2005 Please i need advice.
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2010 7:04pm

What type of machine is the destination? Windows, UNIX, mainframe, something else?
June 17th, 2010 7:15pm

Thanks Wm Gann, I am not sure but i think it is windows. I saw on MSDN this issue can come when the destination is UNIX machine so thats why i am not sure. But i think it is windows. do we need to do configurations settings if it is Windows or do we need to do settings if destination is Unix. Please advice
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2010 7:21pm

I'm a little confused by this. You have to do some configuration no matter what type of server. The fact that you're getting the 200 and 550 messages back from the FTP server means you are connected and that your configuration in SSIS is probably correct. When you manually transferred the file, were you sending to exactly the same place using the same user/password?
June 17th, 2010 9:50pm

Yes i can manually send file to same place using same username and password. Am i doing something wrong. Please advice.
Free Windows Admin Tool Kit Click here and download it now
June 18th, 2010 6:13am

I read that firewall, proxy can block the file to send by using FTP. Please check following paragraph The most common problem encountered when you use FTP over the Internet results when you attempt transfers through a Network Boundary Securing Device (NBSD) such as a proxy, firewall, or Network Address Translation (NAT) device. In most cases the NBSD allows the control connection to be established over TCP 21 (that is, the user can successfully log on to the FTP server), but when the user attempts a data transfer such as DIR, LS, GET, or PUT, the FTP client appears to stop responding because the NBSD is blocking the data connection port that is specified by the client. If the NBSD supports logging, you can verify port blocking by reviewing the deny/reject logs on the NBSD. Could this be an issue. Please advice.
June 18th, 2010 6:54pm

Hi All, I could solve the issue. Firewall was blocking the file to uplaod. Thanks for help.
Free Windows Admin Tool Kit Click here and download it now
June 21st, 2010 7:14pm

When the error happen:"200 Type set to A. 550 An attempt was made to access a socket in a way forbidden by its access permissions." You can set the UsePassiveMode of FTP Connection's attribute from False to True, and that will solve the problem.
November 2nd, 2010 4:07am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics