FTP tool in SQRserver2000
Help!
I have written a few tasks in DTS on SQLserver 2000.
The problem is that the files seem to get deleted as soon as they have been completely downloaded.
The work-arounds we have tried so far are:
* Setting the package commit level to "Read Uncommitted" or even "Chaos"
* Enclosing every FTP task in between SQL tasks "Begin Transaction" and "Commit Transaction"
These work-arounds do not always work.
Can anyone help answer the following questions...
1. Is this a known bug in SQL server 2000?
2. Is there a big fix or patch available?
3. If so, from where can we get it?
4. If not, what work-arounds are other people using?
thanking you very much in advance,
Alex
|