https://community.qlik.com/t5/Talend-Studio/resolved-How-to-retrieve-tFTPFileProperties-results-in-global/m-p/2207190#M6929 Hi,<BR />For each file on a FTP Server, I must copy it and insert his name and date in a database .<BR />I use tFTPFileProperties but how can I retrieve the properties mtime_string and basename in variables ?<BR />You will find below the flow I thought use:<BR />tFTPConnection &gt; tFTPFileList &gt; tFTPFileProperties &gt; ??? &gt; tFTPGet &gt;&nbsp;tMSSqlRow<BR />Regards,<BR />Antoine Tue, 16 Dec 2014 15:03:21 GMT Fernandez 2014-12-16T15:03:21Z https://community.qlik.com/t5/Talend-Studio/resolved-How-to-retrieve-tFTPFileProperties-results-in-global/m-p/2207190#M6929 Hi,<BR />For each file on a FTP Server, I must copy it and insert his name and date in a database .<BR />I use tFTPFileProperties but how can I retrieve the properties mtime_string and basename in variables ?<BR />You will find below the flow I thought use:<BR />tFTPConnection &gt; tFTPFileList &gt; tFTPFileProperties &gt; ??? &gt; tFTPGet &gt;&nbsp;tMSSqlRow<BR />Regards,<BR />Antoine Tue, 16 Dec 2014 15:03:21 GMT https://community.qlik.com/t5/Talend-Studio/resolved-How-to-retrieve-tFTPFileProperties-results-in-global/m-p/2207190#M6929 Fernandez 2014-12-16T15:03:21Z https://community.qlik.com/t5/Talend-Studio/resolved-How-to-retrieve-tFTPFileProperties-results-in-global/m-p/2207191#M6930 Hi, <BR />You can use tFlowToIterate to iterates on the input data and generates global variables. <BR />See my screenshot <BR />Best regards <BR />Sabrina <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MC2V.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129257i0042C46F76DE4112/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MC2V.png" alt="0683p000009MC2V.png" /></span> Wed, 17 Dec 2014 08:40:49 GMT https://community.qlik.com/t5/Talend-Studio/resolved-How-to-retrieve-tFTPFileProperties-results-in-global/m-p/2207191#M6930 Anonymous 2014-12-17T08:40:49Z