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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-29 : 22:47:18
|
David writes "I am using the following:
MS SQL Server 2000 Standard
MS NT Server 4.0 SP 6a
I put a File Transfer Protocol Task in my DTS Package to download a new data file from a remote site. I was able to successfully enter the site/user name/password and select the file and destination that I was to download.
The problem: The file downloads (about 50MB). I can watch in Explorer and see the file size grow. When the download ends, the file is deleted. I am unable to import the file.
I have run this same download using ftp.exe -s:script.ftp successfully. The file downloads and I am able to import.
Question is: why does the file get deleted automatically after the download.
Thanks." |
|
|
|
|
|
Using FTP in DTS to Download a File