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