Re: Unzip file using DTS

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: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
    (microsoft.public.sqlserver.dts)
  • Re: vb.net dataTbl can DTS read?
    ... then using ADO to read/write the data to Sql Server. ... like what DTS does with Text Files, MS Access data, etc. ... Right now I am experimenting with writing the data from ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server DTS From Sybase
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > DataPump is used interchangeably with the transform Data Task ergo not the> ExecuteSQL task ... >>>> I want to import data from a Sybase database via a SQL Server DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server DTS From Sybase
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > DataPump is used interchangeably with the transform Data Task ergo not the> ExecuteSQL task ... >>>> I want to import data from a Sybase database via a SQL Server DTS ...
    (microsoft.public.sqlserver)
  • Re: MS OLAP 3GB Limit
    ... platform is available for the 64-bit platform. ... Is it a requirement to run Data Transformation Services (DTS) on the ... DTS packages in a 64-bit SQL Server database. ... ODBC drivers where can we get this information is there ...
    (microsoft.public.sqlserver.olap)
Loading