FTP Task

• striker-baba

  SSCrazy

  Points: 2170

  More actions

  October 20, 2010 at 9:41 pm

  #241899

  Hi all,

  I have arequirement where I have a bunch of .csv files in my remote FTP serrver.

  I need to connect FTP server and search for group of files with particular name extension and get all those files.

  For ex:

  I have files with following names

  abc_1.csv,

  abc_2.csv,

  abc_3.csv etc.....

  I need to copy all the files with name like abc and bring them from FTP to my local machine........

  Can some one please suggest me any answer....

• striker-baba

  SSCrazy

  Points: 2170

  More actions

  October 20, 2010 at 9:44 pm

  #1240042

  The path I chose is .......................

  I am able to connect to FTP and

  I am able to give a local path to store copied files.

  But for the IsRemotepathvariable------------> I selected as true

  and for the Remote path-------- I am confused on how to specify the folder name

  and also the way to search the .csv files in the folder.......

  please suggest me a solution.....

  Thanks in advance...

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  October 21, 2010 at 12:07 pm

  #1240495

  You have to specify for the remote parameter something like this: <your folder>/abc*.csv

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/