Hi Ian, Such a functionality is not available for direct use. But a design that I can think of is: Poll the root directory every hour using a File System Watcher.Then collect all such files and use a scriupt task to code the logic for ZIP. http://www.codeproject.com/Articles/37887/C-Zip-Files-and-or-FoldersUse a Send Mail Task to send the files.Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

Couple of zip solutions: http://microsoft-ssis.blogspot.com/2011/01/zip-sourcefile-to-archive.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Hello I want to be able to write an SSIS package that will automatically zip the IIS logs that are being generated by our web server, and retain them in the same folder so that they can be retrieved if necessary. All the files are in the same folder, and presently date back to 1st January 2011. Because of the volume of web traffic involved, IIS has been configured to create a new log file every hour, meaning that there are 24 files being generated for a single day. Each filename contains the date on which the file was created, as well as the hour to which it relates. So for example, the log files that were generated for 9th January 2011 are all named "ex110109xx.log", with the last 2 xx's representing the hour to which the log file relates. What I want to be able to do is to write a package that will automatically reach into the appropriate folder, find every log record generated for two days previously, create an archive (.zip preferred) named after the appropriate date and then zip up those files before deleting the actual log files. Ideally I'd want to be able to create a zip file that can be opened with any version of Windows from XP onwards, so that other people needing to carry out remote support don't need special software in order to be able to open the log files. Can anyone point me in the correct direction? ThanksIan Henderson Senior Business Intelligence Analyst (no, really)

could you please check the similar thread Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Everything I've read on that thread seems to rely on a third party archive solution such as WinZip or 7-Zip. However I'm hoping to be able to do something that will use the built in Send To --> Compressed (zip) Folder functionality.Ian Henderson Senior Business Intelligence Analyst (no, really)

Hi Ian, Such a functionality is not available for direct use. But a design that I can think of is: Poll the root directory every hour using a File System Watcher.Then collect all such files and use a scriupt task to code the logic for ZIP. http://www.codeproject.com/Articles/37887/C-Zip-Files-and-or-FoldersUse a Send Mail Task to send the files.Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

Couple of zip solutions: http://microsoft-ssis.blogspot.com/2011/01/zip-sourcefile-to-archive.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter