Windows/SSIS - File Transfer Protocol question

• balasach82

  SSCrazy Eights

  Points: 9653

  More actions

  October 3, 2013 at 9:17 am

  #298581

  Can we download file from an ftp server without knowing the file extension. Directory would have multiple file formats. I dont want to use get *.txt or the like. I know the file name only, but not the extension. Is it doable?

• Kurt W. Zimmerman

  SSCrazy Eights

  Points: 8676

  More actions

  October 3, 2013 at 10:01 am

  #1655625

  Although I have not actually tried it I did find an article that might help you out:

  http://technet.microsoft.com/en-us/library/ms137656.aspx

  Hope this helps.

  Kurt

  Kurt W. Zimmerman
  SR DBA
  Lefrak Organization
  New York, NY

  http://www.linkedin.com/in/kurtwzimmerman