all groups > sql server dts > june 2005 >
You're in the

sql server dts

group:

File Unzip using DTS


File Unzip using DTS mvp
6/30/2005 6:28:04 AM
sql server dts:
Hello,
I am trying to unzip zip files using DTS... Our file were compressed by
using winzip software...If i use WZUNZIP then i am able to unzip file
properly.But if i use
PKUNZIP my unzip file name is being truncated.. i.e if i have
abcdefghijk.zip file
then after unzipping it becomes abc.zip....
So i have a question if files were compressed by WINZIP software, can i
unzip files by using PKUNZIP technically.
And why my file name is truncated after unzipping, when i am using PKUNZIP.

Pls let me know. My sample code is as following...


Set WshShell = CreateObject("WScript.Shell")

'unzip by using WZUNZIP it works fine.
strUnzip = "C:\temp\WZUNZIP -yb c:\temp\zipfiles\test.zip
c:\temp\unzipfiles"

'unzip by using PKUNZIP it also works but it truncate file name after
unzipping.
'let me know what am i doing wrong here.

strUnzip = "C:\temp\PKUNZIP -d c:\temp\zipfiles\test.zip
c:\temp\unzipfiles"

WshShell.Run strUnZip,,true

RE: File Unzip using DTS Ravi
6/30/2005 1:18:05 PM
It looks like PKUNZIP has a file name limitation of 8 charcters (like old
MS-DOS)
--
Thanks
Ravi


[quoted text, click to view]
Re: File Unzip using DTS Ben Rum
7/1/2005 9:23:41 AM
[quoted text, click to view]

The command line version of winzip is free to download, provided you have
the full verion of Winzip 9.0 or greater installed..

http://www.winzip.com/downcl.htm

I use both pkunzip and winzip to extract and compress files via dts
(commands are in .bat file, and DTS calls that file)
I had problems with winzip extracting pkzip files, which is the inverse of
what your are seeing.

Ben

AddThis Social Bookmark Button