FTP SELECTED FILES ONLY using SSIS

• SSISSSRSSSAS

  SSC Enthusiast

  Points: 133

  More actions

  June 23, 2009 at 11:46 am

  #139197

  I am using SQL2008. But it shouldn't matter here. All I am trying is do is FTP files from remote server to my local server. But I need to FTP only files with selected name. Here is an example-

  Remote Server has let's say FOlder called "Full" Now, Inside "Full" folder there can be multiple files with different names and increasing order of 1, 2, 3, and so on

  like A, A1, A2, A3, B, B1, B2, B3, C, D1, D2, D3, Q, Q1, Q2, Q3, Q4..........there is no limitations on how many files will be there of one kind ( so far upto 29)..

  Now using SSIS I just need to FTP files Q, Q1, Q2, Q3, Q4 to my local server into my local folder.

  I don't think I can do this using FTP task but I think a "script component" will help me to achieve this. Does anyone have written similar scripts task or link so that I can start looking into things

  thanks

• bc_

  Hall of Fame

  Points: 3173

  More actions

  June 23, 2009 at 12:55 pm

  #1014182

  take a look at this thread and see if that helps: http://www.sqlservercentral.com/Forums/Topic577774-148-1.aspx

  [font="Arial Narrow"]bc[/font]