Downloading FTP Files in SSIS and unzipping them

• BIsweet

  Old Hand

  Points: 343

  More actions

  August 27, 2009 at 5:48 am

  #138503

  HI, Can any one give me step by step approach

  on creating a package in SSIS in order to download and unzip

  the files from ftp into a certain folder dynamically ?

  It would be really great if i could schedule it as well for

  a certain time, if possible.

  Many Thanks..

• Tim Mitchell

  SSCoach

  Points: 15685

  More actions

  August 27, 2009 at 6:45 am

  #1045475

  You can use the FTP Task in SSIS to download the file from the server to your SSIS server.

  To unzip the file, you'll need an archive tool that supports command line operations. (FWIW, I use Winzip - you have to have the paid version to get the command line support, but it's well documented and supported. There are other freeware and open-source alternatives if you're interested.)

  You'll use the Execute Process task to run the archive tool, passing the parameters to identify the file to unzip and the locationto which it should be extracted. The syntax will vary with each archive application, so you may have to play with it a bit.

  hth,

  Tim

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices

• Paul_J

  Hall of Fame

  Points: 3698

  More actions

  August 27, 2009 at 6:22 pm

  #1045997

  I recommend 7zip for unzipping/zipping.