Hi I am trying to get bunch of .xml.gz file from ftp and copying them to my local folder with the below script in qlikview. But its not working.
If i want to copy files from one local folder to another local folder it works. But for ftp it doesnt work.
'This is a batch file test' As [@echo off]
Let vDate = Date(Today(),'YYYY-MM-DD');
Let vExt = '*.xml.gz';
For Each vFile in FileList('ftp://Username:Password.982@ServerName:21/folder/*.xml.gz')
FIRST 1 Load
'COPY $(vFile) C:\Users\Documents\TestFolder1\$(vDate)'&'_' & SubField('$(vFile)', '\', -1) As [@echo off]
FROM $(vFile) (txt);
Store BatFile into 'C:\Users\Documents\ABC'.bat (txt);
Drop Table BatFile;
Let me know if you have any questions.