Home > SSIS > FTP Task Connection Error – Unable to service PORT commands 500 LPRT

FTP Task Connection Error – Unable to service PORT commands 500 LPRT


This blog post is about an issue I faced while implement SSIS package communication with FTP server. For simplicity, I am going to assume a scenario as a web hosting server with FTP access.

Scenario

My task is to design a package to upload a file to FTP server. I can login to FTP server using FTP tools and perform file system operations such as create, copy, paste and etc. But, my requirement is to automate the process. It is simple that a file need to be copied from a local machine to remote server every hour.

I did design a package that is not very difficult to do and configured the FTP connection and connection tested successfully. But, when I execute the package it throws an error as given below.

Error description

SSIS FTP Task ——————————  An error occurred in the requested FTP operation. Detailed error description: 200 Type set to A 500 Unable to service PORT commands 500 LPRT not understood

I just put the error description in google to find the solution and I found the following reference. It is useful to understand why this problem occurred and not helping me to resolve it.

Microsoft link : http://support.microsoft.com/kb/281193

I did not search further that it may take some more time to resolve and I continue my development. So, I just start looking for some settings to alter connection properties to make the connect successful. Surprisingly, I saw an option in the FTP connection manager to set the connection in passive mode.

I checked that option and executed the package. This time package executed succeeded.

Solution is

Setup FTP connection in passive mode solve this problem.

FTP connection manager screen shot:

pic0

Further Reading

Active and Passive FTP Connections

Send or Receive files from FTP server

Accessing FTP server using script

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: