FTP TASK PROBLEM

Dear all,

I have problem in my ftp task.For example,
I create two variable remotepath and localpath to set up remote and local path of ftp task. And the IsRemotePathVariable and IsLocalPathVariable is set to true.

I create two funtions to retrun the pathvalue. The return value

is like 'D:\A.TXT' , but in DTSX the varible value is changed to 'D:\\A.TXT'. So my ftp task fail.

How can I overcome this problem?

Thanks a lot.

Regards

wen

Replace all occurences of "\\" with "\" if its causing you a problem.

You can do this in an expression.

-Jamie

|||

It doesn't actually change the value. It is just that the undelying engine for SSIS is written in C and "\" is an escape character. To actually display the value of "\" it has to be preceeded by a "\". so to use/display it in a string it appears as "\\". For example \r actually means a carriage return.

As for your situation what error are you getting?

|||

when the path value is changed to "\\" , the error is as bellow,

Error: 0xC0029183 at FTP Task, FTP Task: File represented by "User::FTPPATH" does not exist.
Task failed: FTP Task

sql

FTP Task Editor

When attempting to use SQL Server 2005 FTP task editor remotepath, which I
have mapped directly to the FTP site folder I am using and connected too, th
e
editor keeps giving me an error that the directory doe not exist. Below is
the error I receive.
Error: 0xC002F304 at ftpsite, FTP Task: An error occurred with the following
error message: "Changing current directory to "\F:\Somedirectory\test". 550
'/F:/Somedirectory/test': Not a directory or not accessible.
Has anyone else confronted this issue and is their a known solution?
FYI: The romotepath insist I place a "\" in front of my path or else it will
not recognize the path as a valid path.i've got the same issue - I simply want to log into the ftp server and be in
the default directory it logs into and get a file from there - does anyone
have an answer to this? here is the command for what I want to do, very
simple -
get 'J3.J3PRODM.J1PPB74.AOUSCF5'
not sure if I need the quotes or not but what should the remote path be? I
think the first "/" it requires is throwing it off, here is the error I get
-
Error: 0xC002F304 at FTP AOUSCP1 from BOP, FTP Task: An error occurred with
the following error message: "Changing current directory to "\". 451 HFS
function BPX1SDD gave return code 0000009C, reason code 0B0C00FC
.
--
John F.
"NeedHelp21" wrote:

> When attempting to use SQL Server 2005 FTP task editor remotepath, which I
> have mapped directly to the FTP site folder I am using and connected too,
the
> editor keeps giving me an error that the directory doe not exist. Below i
s
> the error I receive.
> Error: 0xC002F304 at ftpsite, FTP Task: An error occurred with the followi
ng
> error message: "Changing current directory to "\F:\Somedirectory\test". 55
0
> '/F:/Somedirectory/test': Not a directory or not accessible.
> Has anyone else confronted this issue and is their a known solution?
> FYI: The romotepath insist I place a "\" in front of my path or else it wi
ll
> not recognize the path as a valid path.
>