SSIS FTP task / AS400 library

• dave-dj

  SSChampion

  Points: 11297

  More actions

  January 28, 2010 at 5:39 am

  #144557

  HELP!

  I'm going nuts here.

  I'm trying to FTP files from a windows server to an AS400 server. I've been told that when I send the files across I need to do something like the following:

  put MyFile LIBRARY/FILE.MyFile

  I'm not an AS400 person so I presumed that the LIBRARY would act like a directory. It appears to to.

  When setting the remote file path to /Library on the FTP task I get an error

  [Connection manager "FTP Connection Manager"] Error: An error occurred in the requested FTP operation. Detailed error description: 200 Representation type is ASCII nonprint. 200 PORT subcommand request successful. 426-Unable to open or create file /TINBOUND/FGRAINT.GT476_12012010 to receive data. 426 Data transfer ended. .

  I need to put the file into the relevant library and file.

  How can I do this with the FTP task???

  _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  January 28, 2010 at 5:43 am

  #1109890

  Is the FTP enabled on AS400 server??

• dave-dj

  SSChampion

  Points: 11297

  More actions

  January 28, 2010 at 6:06 am

  #1109900

  Yes.

  I can manually connect and place the file on their using put MyFile LIBRARY/File.MyFile.

  I just can't seem to get it to work with SSIS FTP task

  _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

• dave-dj

  SSChampion

  Points: 11297

  More actions

  February 2, 2010 at 4:55 am

  #1112181

  I'm now resolved this.

  My issue was this.

  I was informed by our AS400 guy that files were to be put on the server using a command like this

  put file1 TINBOUND/FGRAIN.file1

  where TINBOUND and FGRAIN represent the AS400 library and file respectively. (file1 would become a file member).

  using the FTP task I was trying to put the remote directory as /TINBOUND/ (I was renaming my upload file to FGRAIN.file1, prior to the ftp task).

  :w00t: To upload the file successfully, I had to instead put the remote ftp directory as /QSYS.LIB/TINBOUND.LIB/FGRAIN.FILE/file1.MBR

  this is Java specific, but it's what helped me resolve the problem, so could be useful to others.

  http://publib.boulder.ibm.com/html/as400/java/rzahhx08.htm

  _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)