ActiveX scripts and files

#1

Is there any way I can zip up files within an ActiveX script?

Thanks,
Ninel

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200608/1

#2

Another option is to use an Execute Process task. You should
be using the command line version of Winzip and execute the
command line exe for WinZip (wzunzip) with the necessary
parameters.

-Sue

On Wed, 23 Aug 2006 14:32:06 GMT, "ngorbunov via
SQLMonster.com" <u9125@uwe> wrote:

Quote:

Is there any way I can zip up files within an ActiveX script?

Thanks,
Ninel

#3

I have the following code within the ActiveX: script:

Code:

sRptFileName = "\\ititpafs01\pds\INETPUB\FTPROOT\accumen\Political\" &
iRowCount1.Value & ".xls"

Dim vCsvFile
Dim vZipFile
Dim mcrZip

vCsvFile =  "\\ititpafs01\pds\INETPUB\FTPROOT\accumen\Political\" &
iRowCount1.Value & ".xls"
vZipFile  =  "\\ititpafs01\pds\INETPUB\FTPROOT\accumen\Political\" &
iRowCount1.Value & ".zip"
mcrZip = "RUN  l:\voicenet\isiti\winzip\wzzip.exe " & vZipFile & " " &
vCsvFile
SHELL(mcrZip)

This is not working.

Can someone please help me out?
Thanks,
Ninel

Sue Hoegemeier wrote:

Quote:

Another option is to use an Execute Process task. You should
be using the command line version of Winzip and execute the
command line exe for WinZip (wzunzip) with the necessary
parameters.

-Sue

Is there any way I can zip up files within an ActiveX script?

Thanks,
Ninel

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200608/1

#4

Just looking at how you are trying to execute winzip, that
won't work.
If I have a file D:\Test\Test.zip
that I want to unzip to the folder D:\SomeDir
I would need to use something like the following in an
ActiveX script:

Dim oShell, strCommand
Set oShell = CreateObject("WScript.Shell")
strCommand = "Wzunzip.exe D:\Test\Test.zip D:\SomeDir"
oShell.Run strCommand

-Sue

On Fri, 25 Aug 2006 14:15:09 GMT, "ngorbunov via
SQLMonster.com" <u9125@uwe> wrote:

Quote:

I have the following code within the ActiveX: script:

Code:

sRptFileName = "\\ititpafs01\pds\INETPUB\FTPROOT\accumen\Political\" &
iRowCount1.Value & ".xls"

Dim vCsvFile
Dim vZipFile
Dim mcrZip

vCsvFile =  "\\ititpafs01\pds\INETPUB\FTPROOT\accumen\Political\" &
iRowCount1.Value & ".xls"
vZipFile  =  "\\ititpafs01\pds\INETPUB\FTPROOT\accumen\Political\" &
iRowCount1.Value & ".zip"
mcrZip = "RUN  l:\voicenet\isiti\winzip\wzzip.exe " & vZipFile & " " &
vCsvFile
SHELL(mcrZip)

This is not working.

Can someone please help me out?
Thanks,
Ninel

Sue Hoegemeier wrote:
Another option is to use an Execute Process task. You should
be using the command line version of Winzip and execute the
command line exe for WinZip (wzunzip) with the necessary
parameters.

-Sue

Is there any way I can zip up files within an ActiveX script?

Thanks,
Ninel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ActiveX scripts and files

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

ActiveX scripts and files - 08-23-2006 , 09:32 AM

Re: ActiveX scripts and files - 08-23-2006 , 12:45 PM

Re: ActiveX scripts and files - 08-25-2006 , 09:15 AM

Re: ActiveX scripts and files - 08-29-2006 , 09:23 AM