|
Home > Archive > MS SQL Server DTS > September 2005 > DTS FTP Task: File disappears after DL!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DTS FTP Task: File disappears after DL!
|
|
| jrazor247 2005-09-30, 3:23 am |
| Hi,
creating FTP task to download file. The file name is determined by
ActiveX script before since the file name is based on the date. It
connects, downloads the entire file (you can see file size increasing
if you refresh in explorer), and then the file vanishes after the task
is complete. these are the only 2 tasks in the package.
Any ideas on what I'm missing here?
Jason
| |
| Darren Green 2005-09-30, 3:23 am |
| jrazor247 wrote:
> Hi,
>
> creating FTP task to download file. The file name is determined by
> ActiveX script before since the file name is based on the date. It
> connects, downloads the entire file (you can see file size increasing
> if you refresh in explorer), and then the file vanishes after the task
> is complete. these are the only 2 tasks in the package.
>
> Any ideas on what I'm missing here?
>
> Jason
>
You need to patch your machine(s). This was fixed in SP1. I strongly
recomend you apply SP4.
FIX: FTP Task in DTS Deletes File from the Destination Folder After the
Package Completes Execution
(http://support.microsoft.com/defaul...kb;en-us;288330)
--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
|
|
|
|
|