Post reply

Task for Zipping Files?

  • January 27, 2009 at 7:31 pm

    #205890

    Hi experts,

    Does SSIS 2005 have a task that will zip a file?

    Thanks, John

  • January 28, 2009 at 2:22 am

    #933668

    Hi,

    You can use Execute Process Task in order to run a zipping program, like winzip, on the server.

    Just write the full path of the program into Executable line and Arguments to be used into Arguments line in the Process properties of the task.

    Regards,

    Sahin.

  • January 28, 2009 at 5:57 am

    #933718

    Thanks Sahi.

    I do not have a licensed copy of Winzip. That is why I was hoping SSIS had a builtin tool for zipping, but no.

    John

  • January 28, 2009 at 6:02 am

    #933726

    See http://qa.sqlservercentral.com/articles/SSIS/64028/

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • January 28, 2009 at 1:09 pm

    #934106

    John Bates (1/27/2009)

    Hi experts,

    Does SSIS 2005 have a task that will zip a file?

    Thanks, John

    Check the Zip Task. It is part of the SSIS+ commercial library, which includes many other great components.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 28, 2009 at 4:22 pm

    #934313

    You could also do it in a Script Task using a zipping library, such as the free SharpZipLib. You will have to put the SharpZipLib DLL in the GAC when you deploy.

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

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