I've found that the FTP Task does not support passive FTP connections.
Does anyone have a workaround?
--
Jame Healy
www.sunaptic.com
Does anyone have a workaround?
--
Jame Healy
www.sunaptic.com
Use an ExecuteProcess task a FTP.exe
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
: Does anyone have a workaround?
--- Microsoft Outlook Express 6.00.2800.1106
I didn't think that ftp.exe supported passive transfers though ... I always
get a 530 ("Only client IP address allowed for PORT command") followed by a
150 ("Opening ASCII mode data connection for ...") that hangs when I try to
ls/dir. I always thought that was a passive issue. No?
Quote:> Hello, Jame!
> Use an ExecuteProcess task a FTP.exe
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> : Does anyone have a workaround?
> --- Microsoft Outlook Express 6.00.2800.1106
I see that ftp.sunaptic.com is running Microsoft FTP Service 5.0. Here is an
actual test session (host name and IP addresses changed) using the ftp.exe
from Windows 2000 with Microsoft FTP Service 5.0:
C:\>ftp ftp.contuso.com
Connected to w2kserver.metrongroup.com.
220 w2ksql Microsoft FTP Service (Version 5.0).
User (ftp.contuso.com:(none)): jsmith
331 Password required for jsmith.
Password:
230-Unauthorized access is prohibited.
230 User jsmith logged in.
ftp> quote pasv
227 Entering Passive Mode (192,168,0,1,6,123).
ftp> dir
200 PORT command successful.
150 Opening ASCII mode data connection for /bin/ls.
drwxrwxrwx 1 owner group 0 Feb 28 20:12 salesfeb
drwxrwxrwx 1 owner group 0 Dec 1 2002 salesnov
226 Transfer complete.
ftp: 138 bytes received in 0.17Seconds 0.81Kbytes/sec.
ftp> bye
221
To automate this, you would create an ftp script file ahead of time (or have
your DTS package generate it in an ActiveX Script Task using the
FileSystemObject, depending on whether its contents need to be dynamic).
Here is an example of what the this file might contain:
jhealy
yourpassword
quote pasv
cd /salesfeb
binary
prompt off
mget *.xls
bye
Let's say that your ftp script file is named c:\download\getsales.scr. You
would invoke ftp.exe with this command line:
ftp ftp.sunaptic.com -s:c:\download\getsales.scr
You can either do this from DTS with an Execute Process Task, or an ActiveX
Script Task which instantiates WScript.WshShell and calls either the Run or
Exec method, depending on how you need to detect/handle ftp errors that
might occur.
> I didn't think that ftp.exe supported passive transfers though ... I
always
> get a 530 ("Only client IP address allowed for PORT command") followed by
a
> 150 ("Opening ASCII mode data connection for ...") that hangs when I try
to
> ls/dir. I always thought that was a passive issue. No?
> > Hello, Jame!
> > Use an ExecuteProcess task a FTP.exe
> > --
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE,MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> > : Does anyone have a workaround?
> > --- Microsoft Outlook Express 6.00.2800.1106
2. db2level ( SQL07010, 02030105, DB2 v7.1.0.24, s010205, U475003)
3. DTS FTP Task: Is it possible to get beyond the root directory of the ftp site
6. pgsql/src/backend/port/beos (sem.c)
7. passive mode FTP for Snapshot
8. Problem reading/writing BLOB data with RDO
10. Replication via Passive FTP
11. !!!! ActiveX document and e-mail and ftp !"!!!!
13. replication with ftp - cryptic ftp server