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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.