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 |
|
msbolton
Starting Member
12 Posts |
 Posted - 2003-03-27 : 08:08:49
|
| I am having a few problems with File Transfer Protocol in SQL Server 2000.I have setup to transfer a file from a box on our network. I have checked the overwrite option to remove files that already exist.When I run the task the file is deleted and the tasks seems to be copying the file across to the destination. However, when I look for the file it does not exist.Any ideas? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-27 : 13:00:40
|
| I have been able to get the File Transfer Protocol to work before but it had limitations, so I just decided to write a batch file instead that did the FTP commands.Have you tried just doing the FTP commands from the cmd shell? If so, do you get any errors?Tara |
 |
|
|
msbolton
Starting Member
12 Posts |
Posted - 2003-03-31 : 07:06:54
|
| Tara,Thanks for the response but I have managed to solve my problem. It is due to a bug is the Transfer task. If you are only transfering one file then the file is copied but then deleted. I have got around at the moment by creating a dummy file to copy over with the file I really need.I am going to fix the problem by installing SP3, which I believe should cure the problem.Thanks for your help.Mark |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-03-31 : 08:41:15
|
| This was a known bug prior to SP1 which should solve the problem.===========Paul |
|
|
|
msbolton
Starting Member
12 Posts |
Posted - 2003-03-31 : 08:47:22
|
| Paul,Thanks for the tip. The server I am using has just been upgarded to SQL Server 2000 so there are no SPs at the moment.If I install the full SP3 I think that this contains the updates from the previous 2 SPs so should solve my problems.Thanks.Mark |
|
|
|
sonmanvb
Starting Member
6 Posts |
Posted - 2003-04-17 : 17:34:12
|
| I was having the same problem and installing sp3 fixed it.Just thought you would like to knowSonny |
|
|
|
|
|
|
Problem with File Transfer Protocol Task