Do any one know who to zip the files. Here is the deal... I am sending tab delimited files from one folder and i want to zip the file once the files are send and then delete those files as i would have backup in the format of zip file. Do any one know regarding the aforesaid.. ie. folder X has 5 tab delimited files once i have send those 5 files i want to zip them inanother folder (folder Y ) with datestamp and then delete those 5 files.

You can use an Execute Process task to call a command line zip utility.

Couldn't you use a command line mode of your zip utility in a ExecuteProcess task?

I can use command line.. but i want a free zip software as i don't want to use winzip or pkzip or other rar.. So do any one know any free zip script software

7-Zip http://www.7-zip.org/ Frank

bhalchandra.kunte wrote: I can use command line.. but i want a free zip software as i don't want to use winzip or pkzip or other rar.. So do any one know any free zip script software Google, Yahoo!, MSN, are all Internet search options that you can use to find the appropriate ZIP software for you to use.

7-Zip http://www.7-zip.org/<=== I have tried but it doen't let me write argument. As well as i have went through google msn and yahoo to find any script which will work as an argument when i am executing 7z or 7zFM or 7zG.. I think 7G can run from command line but ihaven't found any script for that.

I've used 7-zip for tasks similar to what you're trying to do with success. Can you provide more information as to what is not working? this thread might help: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=668303&SiteID=1 Frank

If you value your time, try CozyRoc Zip Task. It works nice.

Why dont you use SharpZip in Script task. Its open source and you can get the package from http://www.icsharpcode.net/OpenSource/SharpZipLib/ Thanks, Shujaat Siddiqi shujaatsiddiqi.blogspot.com

This post describes how to do what you are talking about in detail:http://dataintegrity.wordpress.com/2009/10/13/dynamically-zipping-files-in-ssis/JS

Yes there a way you can use .net library to zip/unzip files.Check BI xPress Snippet Library. They have an excellent example of doing zip/unzip without any 3rd party component. And the best thing about their snippet is ... it support *.zip format (all other example you will see on internet supports only *.gz)http://www.pragmaticworks.com/Products/Business-Intelligence/BIxPress/Once you install BI xPress simpley right click in your package designer and add Snippet -> Select Zip/Unzip File

Yes there a way you can use .net library to zip/unzip files. Check BI xPress Snippet Library. They have an excellent example of doing zip/unzip without any 3rd party component. And the best thing about their snippet is ... it support *.zip format (all other example you will see on internet supports only *.gz) http://www.pragmaticworks.com/Products/Business-Intelligence/BIxPress/ Once you install BI xPress simpley right click in your package designer and add Snippet -> Select Zip/Unzip File SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document Entire BI | SSIS Tasks | BIDS Plugin

Yes there a way you can use .net library to zip/unzip files. Check BI xPress Snippet Library. They have an excellent example of doing zip/unzip without any 3rd party component. And the best thing about their snippet is ... it support *.zip format (all other example you will see on internet supports only *.gz) http://www.pragmaticworks.com/Products/Business-Intelligence/BIxPress/ Once you install BI xPress simpley right click in your package designer and add Snippet -> Select Zip/Unzip File SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document SSIS | SSIS Tasks | Real-time SSIS Monitoring

Here is an example of zipping and archiving sourcefiles once you have processed them: http://microsoft-ssis.blogspot.com/2011/01/zip-sourcefile-to-archive.html