dbTalk Databases Forums  

Why FTP Task fails?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Why FTP Task fails? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jr
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.