Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Using a get a file with SFTP step and executing it in a job.

  1. #1
    Join Date
    Mar 2014
    Posts
    181

    Default Using a get a file with SFTP step and executing it in a job.

    I have a transformation that get yesteradys date and I convert the date into a String of yyyy-mm-dd and use it that to derive a filename path with full qaulified file name path and extension.

    I created two jobs: one job gets yesterdays the copy it in memory.

    The second job takes the values of the first to get the file name from the remote server using a get file with SFTP step.

    My runs fine but it does download the file as expected.

    What am I not doing right?

    Please help me out.

    i have attached both the sample transformation and the logs.

    Thanks,

    Ron

  2. #2
    Join Date
    Mar 2014
    Posts
    181

    Default

    I made some changes in the job. I included the Set Variables step in the DownloadincompleteOrderFiles. Please see attached.
    I can now read read the filepathname string variable but it is not being passed to the get a file with SFTP step.

    Thanks,

    Ron
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.