ActiveX scripts and files -- sql server dts

Sue Hoegemeier
8/23/2006 11:45:18 AM

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
[quoted text, click to view]

ngorbunov via SQLMonster.com
8/23/2006 2:32:06 PM

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.aspx/sql-server-dts/200608/1

ngorbunov via SQLMonster.com
8/25/2006 2:15:09 PM

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)
[/code]

This is not working.

Can someone please help me out?
Thanks,
Ninel

[quoted text, click to view]

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

Sue Hoegemeier
8/29/2006 8:23:38 AM

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
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : ActiveX scripts and files