I am using the following code to zip a text file by using Cygwin. master.dbo.xp_cmdshell 'c:\apps\cygwin\bin\zip.exe -j "D:\ZipMe\TestZip\subdir1\random.zip" "D:\ZipMe\TestZip\subdir1\random.text"'
Now the problem is with the result that random.zip file also include the parent directories information. This code is working fine with old version but gave me odd result the verison ZIP 3.0. Please help me out there.