Hi How to zip the files using SSIS Using only winzip command line. Pls help on this

Check this article using the script task http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/ Alternatively you can use the execute process task aslo invoking the winzip methods

You have to use an Execute Process Task in combination with Winzip commandline. You need an expression for the Argument property of that Execute Process Task. Something like: "-a -ex " + @[user::myZipfile] + " " + @[user::mySourcefile] But personally I preferr a Script Task that (un)zips the files with .Net http://microsoft-ssis.blogspot.com/2011/01/zip-sourcefile-to-archive.html http://microsoft-ssis.blogspot.com/2011/01/unzip-files-with-ssis.htmlPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com