DTS - FTP传输任务中大文件取得后被自动删除！！！

GRANT_Z 2003-09-20 10:53:27

高分求救：

在DTS中设置文件传输协议任务从FTP服务器取一个文件，当文件小的时候没有问题，但是一个10M左右的文件传到本地后被自动删除！！！可是在自己的机器上试却没有此问题（同样的文件，同样的FTP服务器 solaris 自带），是sqlserver有哪方面的限制或者设置吗？？？

...全文

105 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

GRANT_Z 2003-09-23

打赏
举报

我的做法是对DTS编程，设定FTP task 和数据导入 task.

可以在数据转换服务中自己建立新包，选择相应的任务即可阿。

GRANT_Z 2003-09-23

打赏
举报

我的做法是对DTS编程，设定FTP task 和数据导入 task.

可以在数据转换服务中自己建立新包，选择相应的任务即可阿。

hmaple 2003-09-23

打赏
举报

很显然你没有打SP1的patch

seasong 2003-09-22

打赏
举报

问一下，怎么让dts去取ftp文件，并倒入？

GRANT_Z 2003-09-22

打赏
举报

sign, I have got the answer myself.

This was a problem in SQL Server which the Microsoft KB article (Q288330) says that was fixed in SP1.

see detail at:
http://support.microsoft.com/support/kb/articles/Q288/3/30.ASP

SYMPTOMS
When you use an FTP task in Data Transformation Services (DTS) to move files from an FTP server to a destination folder, the last file in the list is deleted from the destination, after the package completes execution. Th file deletion happens when the package is executed from the GUI. If the package is run from the command line using DTSRUN, the last file is partially copied over.

The file is deleted if it is a relatively large file. However, if the last file in the list is a very small file, for example about 2 kilobytes (KB), all the files are moved over successfully.
RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000.

STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000. Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.