all groups > sql server dts > january 2004 >
You're in the

sql server dts

group:

DTS with FTP


DTS with FTP Alexis Arrowsmith
1/28/2004 2:52:24 PM
sql server dts: I have a package that performs a FTP task to download a file.
The FTP step completes successfully but the file is immediately deleted.
I can watch the file download, complete downloading and then it immediately
disappears.
It seems to be associated to one particular file. The file is a zip file
which I can successfully download using the standard windows command line
ftp interface.
I have tried the same file on different FTP servers and different names, but
none work.
Any ideas? Is this something I can address in the DTS FTP Task?

Your help would be appreciated.

Alexis

Re: DTS with FTP Darren Green
1/28/2004 8:54:51 PM
In message <eYQEBhd5DHA.504@TK2MSFTNGP11.phx.gbl>, Alexis Arrowsmith
<nospam-alexis@emj.ca> writes
[quoted text, click to view]

FIX: FTP Task in DTS Deletes File from the Destination Folder After the
Package Completes Execution
http://support.microsoft.com/default.aspx?scid=kb;en-us;288330&Product=sq
l2k
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
Re: DTS with FTP Alexis Arrowsmith
1/29/2004 11:54:15 AM
Thanks for the link, but unfortunately we already have Service Pack 3a

If we get the hot fix specific to this issue are you aware of any issues
with its application with 3A already installed?

Alexis

[quoted text, click to view]

Re: DTS with FTP Darren Green
1/29/2004 8:52:42 PM
In message <uj#EKio5DHA.3896@TK2MSFTNGP11.phx.gbl>, Alexis Arrowsmith
<nospam-alexis@emj.ca> writes
[quoted text, click to view]

Have you applied the SP to the client machine? You should SP all
machines with Enterprise Manager installed not just the server.

Dts is a client side component, so when running a package on your
desktop it is the local set of DLLs that are used not those on the
server.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
AddThis Social Bookmark Button