Why FTP Task fails? -
01-12-2004
, 04:43 AM
Hello,
I hope somebody will clarify this for me. I run download of several text
files from remote server using the following set of bat and txt files:
RunDownoad.bat
--------------
@echo off
ftp -v -i -s:ListFileToDownLoad.txt
ListFileToDownLoad.txt
----------------------
open xx.xx.xx.xx
<USERID>
<PASSWORD>
get file1.data file1.txt
get file2.data file2.txt
get file3.data file3.txt
This works very well.
Since downloaded files have to be imported to SQL server I decided to
set up a DTS package with a FTP Task to replicated downloading task listed
above. There is no problem to connect to the remote ftp server, all seams
to work fine. But, when I try to select files for a download from the
provided
list I see something strange:
file1 DATA V 20 453159 2434 1/05/04 7:20:59
WQA876
file2 DATA V 145 33703 1190 1/09/04 6:37:19
WQA876
file3 DATA V 361 136643 12110 11/06/03 15:43:18
WQA876
Executing a DTS package fails with a following error:
1 task(s) failed during execution.
When double click on failed task it shows:
One or more files could not be transferred.
I also tried to connect to this server using BulletProof FTP client, no
problem
to connect but there is no single file listed. Can anybody give me some
pointer
where to look for a solution.
Thank you,
Janusz R |