Re: Unzip file using DTS

Code on demand. - just happened to use this the other day.

strCommand = "c:\temp\pkunzip test.zip"
Set oShell = CreateObject("WScript.Shell")
oShell.Run strCommand
--
Jim Vierra

"mvp" <mvp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:74880DBA-F472-4EF8-BD29-6D104A66BB7C@xxxxxxxxxxxxxxxx
> Hi Allan,
> Can you pls provide me small code example because i am very new in VB
> Script
> coding. I have already installed cmdline version of winzip.. i do have my
> zip
> file in C:\Temp\Test.zip, so pls provide me small example of activex
> script,
> so that i can create activex task in DTS and test.
>
> thx in advance
>
>
> "Allan Mitchell" wrote:
>
>> I would call the cmdline version of Winzip or PKZip in an ExecuteProcess
>> task.
>>
>>
>>
>> --
>>
>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> www.SQLDTS.com - The site for all your DTS needs.
>> www.SQLIS.com - SQL Server 2005 Integration Services.
>> www.Konesans.com
>>
>>
>> "mvp" <mvp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:EC1C6BF4-0528-45AD-ADED-33584F6CA437@xxxxxxxxxxxxxxxx
>> > Hello everybody,
>> > I have one XML file whcih is a zip file, which i do want to unzip using
>> > DTS
>> > and then want to load XML into SQL SERVER table, so can u pls let me
>> > know,
>> > how can i unzip file using DTS.
>> >
>> > thx
>>
>>
>>


.

Relevant Pages

  • Re: Dynamically set up DTS Transformations?
    ... Allan, I have been stuck on this exact issue for 2 days and have ... > www.SQLDTS.com - The site for all your DTS needs. ... > I have a DTS that transform data between two databases on the same ...
    (microsoft.public.sqlserver.dts)
  • Re: Rows keeps on adding, even after I end DTS process.
    ... "Allan Mitchell" wrote: ... > Did you check to see that the process doing the inserts was dead? ... > you stop a package SQL Server does not stop what it is doing ... >> I have a DTS package which is scheduled daily, ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Import Problem
    ... I'm using the DTS Import Wizard and I've specified the ... "Allan Mitchell" wrote: ... > The error message says you are trying to. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS in SQLServer 7
    ... Thankyou Allan. ... I would like to see the SDK info from 7.0. ... I can see the functions supported in the scripts and the objects. ... >> What is missing in DTS for 7 that is in DTS for 2000? ...
    (microsoft.public.sqlserver.dts)
  • Re: Unzip file using DTS
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I have one XML file whcih is a zip file, which i do want to unzip using DTS ... > how can i unzip file using DTS. ...
    (microsoft.public.sqlserver.dts)
Loading