August 27, 2009 at 5:48 am
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..
August 27, 2009 at 6:45 am
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, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
August 27, 2009 at 6:22 pm
I recommend 7zip for unzipping/zipping.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply