Post reply

How to extract zipped files?

  • March 30, 2010 at 10:23 pm

    #217209

    Hi,

    This problem may be common in this forum. In my folder i have 100 zipped files,i want to unzip all these files at a time.Can anybody suggest me step by step or can anybody send me a link to do this.

    Thanks in advance

  • March 31, 2010 at 9:10 am

    #1143162

    Is this a oneshot deal or something you will need to do over and over?

    CEWII

  • March 31, 2010 at 9:11 am

    #1143164

    elchuru (3/30/2010)

    Hi,

    This problem may be common in this forum. In my folder i have 100 zipped files,i want to unzip all these files at a time.Can anybody suggest me step by step or can anybody send me a link to do this.

    Thanks in advance

    These links should be useful... let me know how it goes..

    http://www.sql-server-performance.com/faq/ssis_unzip_p1.aspx

    http://blog.cybner.com.au/2008/05/unzip-files-using-ssis.html

    there's also 3rd party Control flow task called Zip task

    http://www.cozyroc.com/ssis/zip-task

  • March 31, 2010 at 9:14 am

    #1143168

    It is not for one shot.I want to do everyday using a job

  • March 31, 2010 at 10:28 am

    #1143254

    I'd start with those links. If you have additional questions please ask.

    CEWII

  • April 1, 2010 at 1:34 am

    #1143720

    HI

    U can extract zip files as unzipped data by using EXECUTEPROCESSTASK 🙂

    Maruthi

  • April 1, 2010 at 7:25 am

    #1143945

    You can use the GUNZIP or 7-ZIP to code script in the process task to achieve it.

    There are limitations using GUNZIP. Use 7-Zip instead.

    Rgds

    Seetesh

    Rex Smith

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply