Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tboonleong
Starting Member
24 Posts |
 Posted - 2011-10-15 : 05:03:39
|
| I had gone thru a lot 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 namewhat i need to enter? window server name or SQL server 2008 name? or another server called as FTP server name?b)Server portdefault is 21. But do I need to open TCP/UDP at firewall for each local server and remote server?c) user name and passwordThis 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
SSIS FTP Connection Manager