Removes files and folders from a zip archive

  • Stored Procedure
  • SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017


EXEC @ZipFilePath, @ZipEntryPath


Name Type Description
@ZipFilePath varchar(4000) Full path to an existing zip archive
@ZipEntryPath varchar(4000) Full path to a file or folder within the zip archive. A folder name should be include a forward slash at the end as shown in the example below.


Accessing the file system will be performed in the context of the SQL Server instance process. You can set SQL Server to run using a specific network account, or a Local System Account.

Sample Usage:

Removes a file from a zip archive:
Removes a folder and its content from a zip archive:

See Also: