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 |
|
tdawg69311
Starting Member
4 Posts |
 Posted - 2006-04-28 : 16:43:24
|
| a co-worker and I have been having a similar issue in two completely different packages. We have dts packages put together that have an FTP task inside. When the package runs, the file does not seem to transfer. After further investigation, we both noticed that the file does seem to come over and then is gone after the transfer is complete. having the destination folder open while the task is running, the file starts to be created, but after the task completes the download the file just vanishes. After a little bit of research I hear that this was a common problem prior to service pack 1. Just today one of the IT people installed SP3 locally on my machine (it has long been on the server itself) but I am still having the same problem. Can anyone please help with this problem, I really just do not know where else to look!!!!!!Thanks in advance! |
|
|
tdawg69311
Starting Member
4 Posts |
Posted - 2006-05-04 : 10:54:01
|
| desparation bump to the top |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-04 : 21:56:17
|
| latest is sp4, atleast install sp3abut you need to investigate if the 'vanishing' act is caused by terminated process or an error within the transfer codeadd an error handler so you'll see what's happeningHTH--------------------keeping it simple... |
|
|
|
tdawg69311
Starting Member
4 Posts |
Posted - 2006-05-05 : 08:30:17
|
| I don't believe this is caused by a terminated process, the task seems to be running just fine and "completing" just fine. I've run the task individually and it seems to run perfectly except for the file not being there afterwards. As for the transfer code, I'm not writing any code, I just have an FTP task running so I have no idea how I would look into that. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-05 : 09:48:58
|
| if it 'completes' then it must be there... unless after creation, someone is deleting itfor examples of successful ftp tasks check nr's sitehttp://www.mindsdoor.net/#FTPHTH--------------------keeping it simple... |
|
|
|
tdawg69311
Starting Member
4 Posts |
Posted - 2006-05-05 : 13:22:44
|
| The problem is that I can have the destination folder open while the ftp task is running and I can physically see the file being created and growing larger as it downloads and it grows to the correct size, but the second that the task is completed, the file literally disappears from the folder. it's the strangest thing. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-05 : 17:19:26
|
| Try using FTP.exe and see if the same happens. If it does it's probably a feature of the site.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
FTP problem, file dissappears after transfer Why??