Dynamic FTP Connection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello ,
I wanted to know how to make a dynamic FTP Connection. My
FTP Server will be having a FTP server Name , File path, FTP Server
Name, FTP User Name, FTP Password. Our Database maintains different FTP
servers for different clients.In DTS we used below code in activex
script task to connect to the FTP Dynamically.


"Set objTask =
objPackage.Tasks(cstr("DTSTask_DTSFTPTask_2")).CustomTask

objTask.SourceLocation = 0
objTask.sourcesite = DTSGlobalVariables("g_str_ftpservername").Value
objTask.SourceUsername = DTSGlobalVariables("g_str_ftpusername").Value
objTask.SourcePassword = DTSGlobalVariables("g_str_ftppassword").Value
objTask.NonOverwritable = False
objTask.SourceFilename = srcFiles
objTask.destsite = DTSGlobalVariables("g_str_filelocation").Value

Now we are migrating our workflows to SSIS (SQL Server
2005). The problem is we are unable to find solution for dynamically
connecting to FTP Server which maintains a password.
Can any body help please.
Thanks,
Kiran G

.

Relevant Pages

  • Re: Microsoft FTP Server problem on W2K?
    ... It is a UNISYS ClearPath mainframe system that is trying to FTP using ... passive mode to a MS FTP server. ... Currently the mainframe FTPs in ACTIVE mode. ... Since the mainframe pushes files to our customers over a WAN connection, ...
    (microsoft.public.inetserver.iis.security)
  • RE: FTP Upload
    ... FTP server to the following specified size. ... //set or get the remote path of the FTP server that you want to connect. ... //set the class MessageString. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: FTP Upload
    ... FTP server to the following specified size. ... //set or get the remote path of the FTP server that you want to connect. ... //set the class MessageString. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: vsftpd beginners tutorial?
    ... # This file was created to illustrate the steps needed to create a new FTP ... Why vsftpd as this FTP Server? ... System software customization considerations. ... User and Group Configuration ...
    (RedHat)
  • Re: IPSwitch, Inc. WS_FTP Server
    ... > bounce attack as well as PASV connection hijacking. ... > The FTP bounce vulnerability allows a remote attacker to cause the ... > anonymously along with any internal addresses that the FTP server has ... That means it's got to handle a PORT ...
    (Bugtraq)