Receiving Multiple files through FTP
Hi Currently i have an issue such that on FTP server in folder i have 3 file with different extension jj.txt js.csv jp.go How can i receive jj.txt and js.csv at a time in single FTP Task Please give me idea if you have any ???
October 28th, 2010 5:16pm

Download them all, then using ForEach loop task cycle through them and only process the needed ones. You may use a variable to pick only those files matching the criteria. Something like this http://www.rafael-salas.com/2007/02/ssis-loop-through-files-in-date-range.html illustrates the approach.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 5:21pm

Hi is there any way by which we just select that 2 file in single FTP task like we can do that in DTS???
October 28th, 2010 5:47pm

Just to add a little - the For Each File enumerator has a Files property - set this to *.txt to only process the text files, etc.John Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 5:48pm

but like i have 2.txt file and also i need to choose .csv file basically i mean multiple file with specific file name and extension
October 28th, 2010 6:10pm

You can use two seperate FTP tasks to accomplish this. Since you have specific filenames to download, you'll have to configure the FTP task to download just that file. An alternative scenario is that you could get the list of files to download from a database table in the form of a recordset, then iterate that with a For Each loop. Put your FTP task inside the For Each, so that each file can be downloaded individually.John Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 6:20pm

Can you explaine how to achive alternate scenario
October 28th, 2010 6:28pm

To add to John's post Step 1: Design a FTP Task to enumerate all chosen files at remote location. Step 2: Design a FTP Task to bring all enumerated files to local system. Regards, Raunak J Please 'Mark as Answer' if found helpful
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2010 1:07am

can you please elaborate step 1 that how we can receive multiple file from one FTP task
October 29th, 2010 2:19pm

you can do this in a SINGLE FTP TASK, no need to foreach loop. just look at my sample here: http://rad.pasfu.com/index.php?/archives/28-Transfer-Multiple-Files-from-or-to-FTP-remote-path-to-local-path-SSIS.htmlhttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2010 3:00pm

Reza, he needs to use multiple masks with specific filenames (jj.txt, js.csv). I'm pretty sure the FTP task doesn't support that. *.* as a file mask doesn't work if you have several hundred files in the folder, but you only need two :)John Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com
October 29th, 2010 3:13pm

Reza, he needs to use multiple masks with specific filenames (jj.txt, js.csv). I'm pretty sure the FTP task doesn't support that. *.* as a file mask doesn't work if you have several hundred files in the folder, but you only need two :) John Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com John, you are right, I missed that part of question.I thought that whole files requested to transfer with a single mask. In this case, with two ftp task and two different masks this can be done of course. Thanks for that Johnhttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2010 3:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics