@pujain

I too Compress and UnCompress the Zip files thru SSIS using Execute SQL Task...perhaps you can try this as an alternative....

Add the below code in SQL Statement of Execute SQL Task

XP_CMDSHELL 'C:\Progra~1\WinZip\Winzip32 -min -e "E:\Reports.Zip" "E:\Reports"'

WinZip32 is the Exe located in that folder. This -e switch command is to UnZip; -a is to add files to Zip.

I dont know if there can be any performance impact of side-effects of executing a Exe in this way than using "Execute Process Task". But this way, you can embed this code in job or any T-SQL scripts.

I have attached the Command-Line reference for WinZip exec.

Check out and Post your comments/observations.

In 'Thoughts',

LonelyRogue.