• Hi,

    I never posted back, but I did manage to get FTP to as AS 400 working.

    Manually putting a file on the server, you would do something like the following from the command line replace {} values with your own:

    - start the ftp session and ping to AS/400.

    ftp {YourAS400_IP_ADDRESS}

    User: {AS400_Login}

    Enter pwd: {AS400_Password}

    Add file1 as a new file member to AS/400 file {FileName} in library {LibraryName}

    put file1 {LibraryName}/{FileName}.file1

    - Close the session

    bye

    exit

    When you need to FTP in AS400, getting to the correct library and file is less intuitive.

    Setup your ftp connector to the relevant Server Name and port, with username and password etc.

    In your data flow, add an FTP task.

    To add a new file member to an AS400 library/file, in the FTP Task set the remote path as follows, again, replacing the {} values with your own.

    /QSYS.LIB/{LibraryName}.LIB/{FileName}.FILE

    Note!: You will need to upload your file with a file extension of ".MBR". otherwise, AS400 won't pick up the file.

    I'll leave you to set the other values. if you need any other help, let me know.

    🙂

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)