ZipEntryAppend
Adds files and folders to a new or existing zip archive
- Stored Procedure
- SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017
EXEC SQLHTTP.net.ZipEntryAppend @ZipFilePath, @ZipEntryPath
| Name | Type | Description |
|---|---|---|
| @ZipFilePath | varchar(4000) | Full path to a new or existing zip archive |
| @ZipEntryPath | varchar(4000) | Full path to a file or folder within the zip archive |
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.
Add a file to a new or existing zip archive:
|
1 2 3 4 5 |
EXEC SQLHTTP.net.ZipEntryAppend @ZipFilePath = 'C:\ThisFolderExists\NewOrExistingZipFile.zip', @ZipEntryPath = 'C:\ThisFolderExists\OLEDBProviders.txt' |
|
1 2 3 |
Commands completed successfully. |
Add a folder and its content to a new or existing zip archive:
|
1 2 3 4 5 |
EXEC SQLHTTP.net.ZipEntryAppend @ZipFilePath = 'C:\NewOrExistingZipFile.zip', @ZipEntryPath = 'C:\ThisFolderExists' |
|
1 2 3 |
Commands completed successfully. |
- CodePageEncodings
- FileCopy
- FileDecrypt
- FileDelete
- FileEncrypt
- FileMove
- FileRead
- Files_To_Table
- FileWrite
- FolderCopy
- FolderCreate
- FolderDelete
- FolderMove
- Folders_To_Table
- GlobalTable_To_File
- IsExistingFile
- IsExistingFolder
- TempPath
- ZipEntryAppend
- ZipEntryRemove
- ZipExtract_To_Folder
- ZipExtract_To_Table