<div>
Perhaps you would consider using DTS instead of xp_cmdshell ?
</div>


Perhaps you would consider using DTS instead of xp_cmdshell ?

<div>
Would you please show me how? thanks.
</div>


<div>
This is big help, can I know how to do this using DTS?
</div>


This is big help, can I know how to do this using DTS?

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
I can unzip a txt file by using the code below, however, I have more then 70 txt files that need to done in one procedure, how can I do? please advice. Thank you.<br />
<br />
EXEC master..xp_cmdshell 'C:\Progra~1\utility\WinZi<wbr />p\winzip32<wbr /> -e C:\DATA\FTP_Download\ca_ac<wbr />count_sale<wbr />s_org.zip C:\DATA\FTP_Download\ '<br />

</div>
</div>


Hi experts,

I can unzip a txt file by using the code below, however, I have more then 70 txt files that need to done in one procedure, how can I do? please advice. Thank you.

EXEC master..xp_cmdshell 'C:\Progra~1\utility\WinZip\winzip32 -e C:\DATA\FTP_Download\ca_account_sales_org.zip C:\DATA\FTP_Download\ '


Unzip txt file by using *.txt?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.