hi, I need to unzip a .gz file to create a package. The input for my table are in the .gz file and i am unable to open and retrieve from there. I need to immedeatly create a package. and also i am unable to download any third party software since there is no privelages. Please help me . Thank you in advance.

You can do that with a Script Task (No third party software needed): http://msdn.microsoft.com/en-us/library/system.io.compression.gzipstream.aspx http://msdn.microsoft.com/en-us/library/system.io.compression.compressionmode And here is a forum thread: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/00f110d9-9be8-481c-9696-75be9973e728 Should be something like this unzip script task example (only with an other script, because it's zip instead of gzip): 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

You can do that with a Script Task (No third party software needed): http://msdn.microsoft.com/en-us/library/system.io.compression.gzipstream.aspx http://msdn.microsoft.com/en-us/library/system.io.compression.compressionmode And here is a forum thread: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/00f110d9-9be8-481c-9696-75be9973e728 Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

You can do that with a Script Task: http://msdn.microsoft.com/en-us/library/system.io.compression.gzipstream.aspx Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com