I had gone thru some articles and I still not sure the information that required for setup the FTP task at ssis. scenario : I have a SQL server 2008 with window server 2008 and want to ftp a zipped text file to a remote pc. At the FTP connection manager editor screen : a)server name what i need to enter? window server name or SQL server 2008 name? or another server called as FTP server name? b)Server port default is 21. But do I need to open TCP/UDP at firewall for each local server and remote server? c) user name and password This is for SQL server 2008 or window server 2008 user ???which 1? I keep trying a lot but I still hit error show as below : The connection can not be established.server name or port no or credential may be invalid. Appreciate if can get any help.Thanks

1) You need to provide FTP Servername 2) Default port is 21 and it should be open at both client and server 3) FTP task support either anonymous or basic authentication. You have to try for the ftp server connection username, password.Venkataraman R

1) In my case where the sql server 2008 will using ssis tool(FTP task) to push the zipped text file to the remote pc. Then do I must setup another server called as FTP server. Or I need to setup the sql server 2008 also act as FTP server? FYI ALL FTP is using LAN only. 2) Do I also need to open the default data port 20 on both client and server? As I understand that a normal FTP will need both default command port 21 and data port 21. Thanks a lot for your kind assistant.

do you want to transfer the zipped file to another location at the local network? I mean you have access to destination server through network? if yes, you can copy file simply with File System Task, but if you want to reach to destination server through internet, you probably have a FTP address, ftp account, you should enter them all in the ftp connection manager in SSIS. http://www.rad.pasfu.com