dbTalk Databases Forums  

FTP Task issue

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


Discuss FTP Task issue in the microsoft.public.sqlserver.dts forum.



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

Default FTP Task issue - 02-24-2006 , 12:56 PM






I'm running into an issue with the FTP Task. I'm using FTP Task in a
Foreach loop to retrieve a file which is specified in a variable being
populated in the Foreach loop. I'm specifying the Remote Path as a
variable which will look something like this:
"/folder1/folder2/filename".

However, if I include the "/" at the beginning of the Remote Path then
I get this error:

"Changing current directory to "\folder1\folder2". 550
/folder1/folder2: No such file or directory."
..
And if I go to an ftp client and try to "cd \folder1\folder2" then I
get the same error message. But removing the "\" works.

So then I tried removing the "/" from the Remote Path variable, and
started getting this error:

"Variable "CurrRemoteFilePath" doesn't start with "/"."

So it is not working either way! Any suggestions?

Thank you!
Trevor Brierly


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.