+ Reply to Thread
Results 1 to 2 of 2

SSIS FTP Task -- Problem

  1. SSIS FTP Task -- Problem

    I am attempting to send files from Windows to linux ftp. I am getting this
    error message which I am not able to understand. I have tried all the options
    but have run out of them.

    [Connection manager "FTP Connection Manager"] Error: An error occurred in
    the requested FTP operation. Detailed error description: 200 Type set to A
    227 Entering Passive Mode (207,217,96,15,230,200). 550
    /share/RLD/Dev_Files/Case_ATL_20090101.txt: Forbidden filename .

    My Remote Path is a variable and is defined as "/share/RLD/Dev_Files/"

    My recieve is working fine.

    Please help.

  2. RE: SSIS FTP Task -- Problem

    I think the key is found in the last two words of your error message:
    "Forbidden filename"

    If you are using variables to determine location and/or filename, then set a
    breakpoint on the "On Pre Execute" event of the FTP task in question and
    examine the contents of the variable(s) before the task executes.

    Remember that if you are using expressions to set the contents of a
    varialbe, and you have literals in the expression, you need to watch for any
    reserved character and properly 'escape' it. So, for example, you might need
    to have the following:

    "\\\\MyShareName\\MyfolderName\\" + [User::FileName]

    I noticed your path has forward slashed instead of back slashes. Is that a
    Linux thing? Do you need to double up the slash before "share"?

    HTH
    =====
    Todd C


    "Vishwanathan Raman" wrote:

    > I am attempting to send files from Windows to linux ftp. I am getting this
    > error message which I am not able to understand. I have tried all the options
    > but have run out of them.
    >
    > [Connection manager "FTP Connection Manager"] Error: An error occurred in
    > the requested FTP operation. Detailed error description: 200 Type set to A
    > 227 Entering Passive Mode (207,217,96,15,230,200). 550
    > /share/RLD/Dev_Files/Case_ATL_20090101.txt: Forbidden filename .
    >
    > My Remote Path is a variable and is defined as "/share/RLD/Dev_Files/"
    >
    > My recieve is working fine.
    >
    > Please help.


+ Reply to Thread