How to unzip files in DTS package?

EXEC master..xp_cmdshell "C:\Progra~1\utility\WinZip\winzip32 -e
'C:\DATA\FTP_Download\ca_account_sales_org.zip C:\DATA\FTP_Download\'"

EXEC master..xp_cmdshell "C:\Progra~1\utility\WinZip\winzip32 -e C:\DATA\FTP_Download\ca_account_sales_org.zip C:\DATA\FTP_Download\ "

This is not works.

It hangs:

EXEC master..xp_cmdshell "C:\Progra~1\utility\WinZip\winzip32 -e
'C:\DATA\FTP_Download\ca_account_sales_org.zip C:\DATA\FTP_Download\'"

I have to kill it.

Hi aneeshattingal,

EXEC master..xp_cmdshell "C:\Progra~1\utility\WinZip\winzip32 -e C:\DATA\FTP_Download\ca_account_sales_org.zip C:\DATA\FTP_Download\ "

this is not work neither, it hangs too.

EXEC master..xp_cmdshell "C:\Progra~1\utility\WinZip\winzip32 -e
'C:\DATA\FTP_Do~1\ca_acc~1.zip C:\DATA\FTP_Do~1\'"

It hangs again.

Hi aneeshattingal,

Do you have time to this issue?

I have no idea why it is not working, I know the code should be run. Any help appreciate.

Hi experts,

I tried the following command at C:\prompt at my laptop which has SQL server indevidual version installed and it works.

C:>C:\progra~1\utility\Winzip\Winzip32 -e C:\DATA\FTPDownload\ca_accounts.zip C:\DATA\FTPDownload\

However, when I copy the same code to SQL Query Analyzer, it give me an error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '\'.
Server: Msg 132, Level 15, State 1, Line 2
The label 'C' has already been declared. Label names must be unique within a query batch or stored procedure.
Server: Msg 132, Level 15, State 1, Line 2
The label 'C' has already been declared. Label names must be unique within a query batch or stored procedure.

Any help would appraciate

Hi nito8300,

Thank you for the valuable feedback, this is really big help.

welcome