DSXchange

To import multible ftp files I created bat file:

ftp -s:E:\data\PROD\TEMPFILES\FINTRANS\GETFINTRANSMD.parm hostname

parm file holds the following content:

username
password
text
cd correct_path
prompt
mget File*.EXP
bye


running bat file from cmd (outside datastage) works perfect
From DS Job tried two things.

cmd stage calling the bat file - which I expected to work with no problem
but it returns

FTPTEMPLTEST..Command_Stage_0: User (hostname:(none)): Invalid command.
Interactive mode Off .

Then I tried file stage with BeforeJobRoutine as
both bat file, as well as with full string :
ftp -s:E:\data\PROD\TEMPFILES\FINTRANS\GETFINTRANSMD.parm hostname

Both returns
*** Output from command was: ***
User (hostname:(none)): Invalid command.


Anybody has the magic touch ???

Is drive "E" a local drive or a remotely mounted one?

ArndW wrote:Is drive "E" a local drive or a remotely mounted one?

A local physical drive

Strange indeed. Are you passing a constant string value for "hostname" in your DS job?

ArndW wrote:Strange indeed. Are you passing a constant string value for "hostname" in your DS job?

No - it is only listed in the batch file

ArndW wrote:Strange indeed. Are you passing a constant string value for "hostname" in your DS job?

No - it is only listed in the batch file

If you put an echo in the bat file does that print out to the log, i.e. does the BAT file get called correctly?

empty entry

RESOLVED

Removed hostname from bat file and started params file with open host.
and removede TEXT
TEXT was what initiated the "invalid command"

new param file:

open hostname
username
password
cd correct path
prompt
lcd Targetdirectory
mget FILES*.EXP
bye

Thanks for the promp assistance

What was 'text' supposed to accomplish? Did you perhaps mean 'ascii' instead?

Please mark your post as Resolved using the button at the top of the page. Thanks.

Thought I had marked it already

TEXT = ASCII