DTS needs to unzip file

#1

I have a DTS job on a Windows 2000 AS server and SQL Server 2000, which needs
to unzip a zip file as the first step of the transform and load.

My understanding is that Windows 2000 AS Server has a base function to unzip
items that you click on (in much the same way that XP does).

Thus I was looking for a reference to a Script Host or some other command to
embed in the DTS job to perform the unzip.

Third-party tools such as WinZip probably can't be used since this is a
locked down server.

Thanks.

#2

Just use the Execute Process Task in DTS.

Winzip has command line tools. No need for WSH.

"Alex Rau" wrote:

Quote:

I have a DTS job on a Windows 2000 AS server and SQL Server 2000, which needs
to unzip a zip file as the first step of the transform and load.

My understanding is that Windows 2000 AS Server has a base function to unzip
items that you click on (in much the same way that XP does).

Thus I was looking for a reference to a Script Host or some other command to
embed in the DTS job to perform the unzip.

Third-party tools such as WinZip probably can't be used since this is a
locked down server.

Thanks.

#3

Are you looking for EXPAND on the command line?

"Alex Rau" wrote:

Quote:

I have a DTS job on a Windows 2000 AS server and SQL Server 2000, which needs
to unzip a zip file as the first step of the transform and load.

My understanding is that Windows 2000 AS Server has a base function to unzip
items that you click on (in much the same way that XP does).

Thus I was looking for a reference to a Script Host or some other command to
embed in the DTS job to perform the unzip.

Third-party tools such as WinZip probably can't be used since this is a
locked down server.

Thanks.

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

DTS needs to unzip file

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

DTS needs to unzip file - 03-01-2005 , 01:09 PM

RE: DTS needs to unzip file - 03-02-2005 , 03:47 PM

RE: DTS needs to unzip file - 03-03-2005 , 02:55 AM