I have 72 .txt.z files in c: \data\ftp_download folder and need to unzipped to the same folder. I have winzip pro and command line add- on installed in my PC, because Wzunzip support .zip files only. Is any simple way can unzip them by using any SQL server tools?
DECLARE @FileName VARCHAR(50)
DECLARE @SQL VARCHAR(2000)
set @FileName = '*.txt.z'
SET @SQL ='C:\Progra~1\WinZip\wzunzip -yb -o C:\DATA\FTP_Download\' + @FileName + ' C:\DATA\FTP_Download\'
EXEC master..xp_cmdshell @SQL
End-of-central-directory signature not found. Either this file is not a Zip file, or it constitutes one disk of a multi-part Zip file.