hello allI'm tring to create an ssis package that will load txt import files.problem: the files in the source location are zipped.I must concern the next mandatory rules:1. The ssis package will be automaticlly run at server:windows server 2003.2. No useof commercial or freeware zip utility.3. The?Unzip process will run in loop on all zip files and extract them.4. automaticly on server - noextract progress windowsany idea?udiDevOnVb

Here is a potential SSIS unzip/zip solution.Let us know if helpful.Kalman Toth, SQL Server 2005 Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com

You could also look at this solution too as another alternative -Decompress Zip files with Windows Shell API and C#.Some other options and libraries you could reference are:ZLIB.NETSharpZipLib Demo useing SharpZipLib within WinForms for reference:Zip Compress and Decompress - Win Forms DemoHere are some additional other links directly related to SSIS for you to reference:How do you unzip a file in an SSIS package?SSIS Compress File Task now with added decompression Dan English -- http://denglishbi.spaces.live.com

We do exactly what you have described using the native .Net classes,GZipStream, in a script task and it works like a charm. Find one of the many code samples that have been posted here and modify to your requirements.

You could also try the open-source TaskUnZip task on CodePlex:http://www.codeplex.com/TaskUnZip

Here is an example to unzip ZIP files (not gzip) with a script task: http://microsoft-ssis.blogspot.com/2011/01/unzip-files-with-ssis.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com