---
product: Chilkat
product_version: 11.7.0
language: sqlserver
language_label: SQL Server
class: Tar
license: bundle
deprecated: false
reference_html: https://www.chilkatsoft.com/refdoc/sqlserver_TarRef.html
---
# Chilkat Tar — SQL Server — v11.7.0

> Chilkat 11.7.0 · language=sqlserver · class=Tar
> Other versions: replace `11.7.0` in this URL. Other languages: `https://www.chilkatsoft.com/ai-docs/v/11.7.0/<lang>/classes/Tar.md`.
> Language-wide rules (install, unlock, error model, strings/bytes): `https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/guide.md`.

## Purpose

**Create, list, verify, filter, and extract TAR archives and compressed TAR formats.**

`Chilkat.Tar` creates, verifies, lists, and extracts TAR archives, including compressed TAR formats such as `.tar.gz`, `.tgz`, `.tar.bz2`, and `.tar.Z`. It supports adding individual files and directory trees, controlling archive paths, preserving or overriding file permissions, filtering included or extracted files, extracting from memory, extracting selected entries to memory or `BinData`, producing XML listings, and creating Debian `.deb` package archives from control and data tarballs.

**Create TAR archives**

Add files or directory trees and write standard TAR output, with control over archive paths, directory handling, and write format.

**Compressed TAR formats**

Work with common compressed archive forms such as `.tar.gz`, `.tgz`, `.tar.bz2`, and `.tar.Z`.

**List and verify contents**

Inspect archive entries, verify archive structure, and produce XML listings for display, logging, or programmatic processing.

**Selective extraction**

Extract entire archives or selected entries, including workflows that extract matching files directly to memory or `BinData`.

**Filters and paths**

Include or exclude files using filters, control relative paths in the archive, and manage how entries are restored during extraction.

**Permissions and packages**

Preserve or override UNIX-style permissions and create Debian `.deb` package archives from control and data tarballs.

**Common pattern:** Use `Tar` when the data is a TAR archive or a compressed TAR archive. Configure the archive paths, filters, permissions, and compression format, then create, list, verify, or extract the archive as needed. Use `Chilkat.Zip` for ZIP archives, `Chilkat.Gzip` for a single GZIP stream, and `Chilkat.Compression` for raw compression operations.

For an extended overview, see [Tar Class Overview](https://www.chilkatsoft.com/tar_class_overview.asp).

## Object creation, unlocking and error handling

**Object Creation**

```sql
DECLARE @hr int
DECLARE @tar int
EXEC @hr = sp_OACreate 'Chilkat.Tar', @tar OUT
IF @hr <> 0
BEGIN
    PRINT 'Failed to create ActiveX component'
    RETURN
END

-- ... use @tar ...

EXEC @hr = sp_OADestroy @tar
```

T-SQL uses the Chilkat ActiveX through the OLE Automation stored procedures. They must be enabled once on the server (`EXEC sp_configure 'Ole Automation Procedures', 1; RECONFIGURE;`), and the Chilkat ActiveX registered must match the bitness of the SQL Server instance (64-bit for a 64-bit SQL Server). To bind to a specific major version of Chilkat, append the major version number to the ProgID, such as `sp_OACreate 'Chilkat.Tar.11'` for Chilkat v11.\*.\*.

`sp_OACreate` returns an object token (an `int`) that is passed as the first argument of every `sp_OAMethod`, `sp_OAGetProperty` and `sp_OASetProperty` call, and released with `sp_OADestroy`. Objects returned by methods (such as an `HttpResponse` or `JsonObject`) are also tokens received through an `int` OUT parameter; they must likewise be destroyed, and the OUT parameter is `NULL` when the method fails to return an object. Objects passed as arguments are passed by their token. When an OLE Automation procedure itself fails (non-zero `@hr`), `sp_OAGetErrorInfo` describes the error.

Data types: strings are `nvarchar(4000)`; integers, booleans (1 or 0) and object tokens are `int`; dates are `datetime`. In the signatures on this page, `@success`, `@iResult`, `@sResult` and the like are the OUT variables receiving a method's return value, `@iValue` / `@sValue` receive or supply a property value, and the remaining `@` variables are the method's arguments in order.

A string returned through an OUT parameter is limited to 4000 characters. For longer values, retrieve the result as a result set into a table variable instead of an OUT parameter, for example `DECLARE @tmp TABLE (outputLine ntext)` followed by `INSERT INTO @tmp EXEC sp_OAGetProperty @tar, 'LastErrorText'`. See [string length limitations for strings returned by sp_OAMethod calls](https://www.chilkatsoft.com/sql_server_nvarchar_max_limitation.asp).

Methods that pass or return raw byte arrays are not shown on this page, because `varbinary(max)` values cannot be exchanged through `sp_OAMethod` (see [varbinary(max) limitation](https://www.chilkatsoft.com/sql_server_varbinary_max_limitation.asp)). Use the `BinData`-based alternatives (methods ending in *Bd*) or the base64 / hex string-encoded variants instead. Binary *properties* (such as `LastBinaryResult`) can be retrieved as a result set into a table variable, as shown in their signatures. Asynchronous (*\*Async*) methods and event callbacks are not available from SQL Server.

Call `Global.UnlockBundle` once at the start of the program, before using this or any other Chilkat class. Any string unlocks a fully functional 30-day trial; a purchased unlock code is used in production. See `guide.md` for the exact code in SQL Server.

How failure is reported depends on the method's return type and is stated in the note under each method below. In every case the diagnostic text is in the `LastErrorText` property of the object whose method was called.

## Members common to every Chilkat class

Documented once per language in `common-members.md`; listed here so this page is self-contained.

| Property | Signature | Access | Meaning |
|---|---|---|---|
| `DebugLogFilePath` | `EXEC sp_OAGetProperty @tar, 'DebugLogFilePath', @sValue OUT EXEC sp_OASetProperty @tar, 'DebugLogFilePath', @sValue` | read/write | If set to a file path, this property logs the LastErrorText of each Chilkat method or property call to the specified file. |
| `LastBinaryResult` | `INSERT INTO @tmp EXEC sp_OAGetProperty @tar, 'LastBinaryResult'` | read-only | This property is mainly used in SQL Server stored procedures to retrieve binary data from the last method call that returned binary data. |
| `LastErrorHtml` | `EXEC sp_OAGetProperty @tar, 'LastErrorHtml', @sValue OUT` | read-only | Provides HTML-formatted information about the last called method or property. |
| `LastErrorText` | `EXEC sp_OAGetProperty @tar, 'LastErrorText', @sValue OUT` | read-only | Provides plain text information about the last called method or property. |
| `LastErrorXml` | `EXEC sp_OAGetProperty @tar, 'LastErrorXml', @sValue OUT` | read-only | Provides XML-formatted information about the last called method or property. |
| `LastMethodSuccess` | `EXEC sp_OAGetProperty @tar, 'LastMethodSuccess', @iValue OUT EXEC sp_OASetProperty @tar, 'LastMethodSuccess', @iValue` | read/write | Indicates the success or failure of the most recent method call: `1` means success, `0` means failure. |
| `LastStringResult` | `EXEC sp_OAGetProperty @tar, 'LastStringResult', @sValue OUT` | read-only | In SQL Server stored procedures, this property holds the string return value of the most recent method call that returns a string. |
| `LastStringResultLen` | `EXEC sp_OAGetProperty @tar, 'LastStringResultLen', @iValue OUT` | read-only | The length, in characters, of the string contained in the LastStringResult property. |
| `VerboseLogging` | `EXEC sp_OAGetProperty @tar, 'VerboseLogging', @iValue OUT EXEC sp_OASetProperty @tar, 'VerboseLogging', @iValue` | read/write | If set to `1`, then the contents of LastErrorText (or LastErrorXml, or LastErrorHtml) may contain more verbose information. |
| `Version` | `EXEC sp_OAGetProperty @tar, 'Version', @sValue OUT` | read-only | Version of the component/library, such as "10.1.0" |

## Member index

| Member | Kind | Signature |
|---|---|---|
| `CaptureXmlListing` | property, read/write | `EXEC sp_OAGetProperty @tar, 'CaptureXmlListing', @iValue OUT EXEC sp_OASetProperty @tar, 'CaptureXmlListing', @iValue` |
| `Charset` | property, read/write | `EXEC sp_OAGetProperty @tar, 'Charset', @sValue OUT EXEC sp_OASetProperty @tar, 'Charset', @sValue` |
| `DirMode` | property, read/write | `EXEC sp_OAGetProperty @tar, 'DirMode', @iValue OUT EXEC sp_OASetProperty @tar, 'DirMode', @iValue` |
| `DirPrefix` | property, read/write | `EXEC sp_OAGetProperty @tar, 'DirPrefix', @sValue OUT EXEC sp_OASetProperty @tar, 'DirPrefix', @sValue` |
| `FileMode` | property, read/write | `EXEC sp_OAGetProperty @tar, 'FileMode', @iValue OUT EXEC sp_OASetProperty @tar, 'FileMode', @iValue` |
| `GroupId` | property, read/write | `EXEC sp_OAGetProperty @tar, 'GroupId', @iValue OUT EXEC sp_OASetProperty @tar, 'GroupId', @iValue` |
| `GroupName` | property, read/write | `EXEC sp_OAGetProperty @tar, 'GroupName', @sValue OUT EXEC sp_OASetProperty @tar, 'GroupName', @sValue` |
| `MatchCaseSensitive` | property, read/write | `EXEC sp_OAGetProperty @tar, 'MatchCaseSensitive', @iValue OUT EXEC sp_OASetProperty @tar, 'MatchCaseSensitive', @iValue` |
| `MustMatch` | property, read/write | `EXEC sp_OAGetProperty @tar, 'MustMatch', @sValue OUT EXEC sp_OASetProperty @tar, 'MustMatch', @sValue` |
| `MustNotMatch` | property, read/write | `EXEC sp_OAGetProperty @tar, 'MustNotMatch', @sValue OUT EXEC sp_OASetProperty @tar, 'MustNotMatch', @sValue` |
| `NoAbsolutePaths` | property, read/write | `EXEC sp_OAGetProperty @tar, 'NoAbsolutePaths', @iValue OUT EXEC sp_OASetProperty @tar, 'NoAbsolutePaths', @iValue` |
| `NumDirRoots` | property, read-only | `EXEC sp_OAGetProperty @tar, 'NumDirRoots', @iValue OUT` |
| `ScriptFileMode` | property, read/write | `EXEC sp_OAGetProperty @tar, 'ScriptFileMode', @iValue OUT EXEC sp_OASetProperty @tar, 'ScriptFileMode', @iValue` |
| `SuppressOutput` | property, read/write | `EXEC sp_OAGetProperty @tar, 'SuppressOutput', @iValue OUT EXEC sp_OASetProperty @tar, 'SuppressOutput', @iValue` |
| `UntarCaseSensitive` | property, read/write | `EXEC sp_OAGetProperty @tar, 'UntarCaseSensitive', @iValue OUT EXEC sp_OASetProperty @tar, 'UntarCaseSensitive', @iValue` |
| `UntarDebugLog` | property, read/write | `EXEC sp_OAGetProperty @tar, 'UntarDebugLog', @iValue OUT EXEC sp_OASetProperty @tar, 'UntarDebugLog', @iValue` |
| `UntarDiscardPaths` | property, read/write | `EXEC sp_OAGetProperty @tar, 'UntarDiscardPaths', @iValue OUT EXEC sp_OASetProperty @tar, 'UntarDiscardPaths', @iValue` |
| `UntarFromDir` | property, read/write | `EXEC sp_OAGetProperty @tar, 'UntarFromDir', @sValue OUT EXEC sp_OASetProperty @tar, 'UntarFromDir', @sValue` |
| `UntarMaxCount` | property, read/write | `EXEC sp_OAGetProperty @tar, 'UntarMaxCount', @iValue OUT EXEC sp_OASetProperty @tar, 'UntarMaxCount', @iValue` |
| `UserId` | property, read/write | `EXEC sp_OAGetProperty @tar, 'UserId', @iValue OUT EXEC sp_OASetProperty @tar, 'UserId', @iValue` |
| `UserName` | property, read/write | `EXEC sp_OAGetProperty @tar, 'UserName', @sValue OUT EXEC sp_OASetProperty @tar, 'UserName', @sValue` |
| `WriteFormat` | property, read/write | `EXEC sp_OAGetProperty @tar, 'WriteFormat', @sValue OUT EXEC sp_OASetProperty @tar, 'WriteFormat', @sValue` |
| `XmlListing` | property, read/write | `EXEC sp_OAGetProperty @tar, 'XmlListing', @sValue OUT EXEC sp_OASetProperty @tar, 'XmlListing', @sValue` |
| `AddDirRoot` | method | `EXEC sp_OAMethod @tar, 'AddDirRoot', @success OUT, @dirPath` |
| `AddDirRoot2` | method | `EXEC sp_OAMethod @tar, 'AddDirRoot2', @success OUT, @rootPrefix, @rootPath` |
| `AddFile` | method | `EXEC sp_OAMethod @tar, 'AddFile', @success OUT, @path` |
| `AddFile2` | method | `EXEC sp_OAMethod @tar, 'AddFile2', @success OUT, @filePath, @pathWithinTar` |
| `ClearDirRootsAndFiles` | method | `EXEC sp_OAMethod @tar, 'ClearDirRootsAndFiles', @success OUT` |
| `CreateDeb` | method | `EXEC sp_OAMethod @tar, 'CreateDeb', @success OUT, @controlPath, @dataPath, @debPath` |
| `GetDirRoot` | method | `EXEC sp_OAMethod @tar, 'GetDirRoot', @sResult OUT, @index` |
| `ListXml` | method | `EXEC sp_OAMethod @tar, 'ListXml', @sResult OUT, @tarPath` |
| `Untar` | method | `EXEC sp_OAMethod @tar, 'Untar', @iResult OUT, @tarPath` |
| `UntarBz2` | method | `EXEC sp_OAMethod @tar, 'UntarBz2', @success OUT, @tarPath` |
| `UntarFirstMatchingToBd` | method | `EXEC sp_OAMethod @tar, 'UntarFirstMatchingToBd', @success OUT, @tarPath, @matchPattern, @bd` |
| `UntarGz` | method | `EXEC sp_OAMethod @tar, 'UntarGz', @success OUT, @tarPath` |
| `UntarZ` | method | `EXEC sp_OAMethod @tar, 'UntarZ', @success OUT, @tarPath` |
| `VerifyTar` | method | `EXEC sp_OAMethod @tar, 'VerifyTar', @success OUT, @tarPath` |
| `WriteTar` | method | `EXEC sp_OAMethod @tar, 'WriteTar', @success OUT, @tarPath` |
| `WriteTarBz2` | method | `EXEC sp_OAMethod @tar, 'WriteTarBz2', @success OUT, @bz2Path` |
| `WriteTarGz` | method | `EXEC sp_OAMethod @tar, 'WriteTarGz', @success OUT, @gzPath` |

## Properties

### Tar.CaptureXmlListing

`Chilkat 11.7.0 · sqlserver · Tar · CaptureXmlListing · property · read/write · since 9.5.0.46`

```sql
EXEC sp_OAGetProperty @tar, 'CaptureXmlListing', @iValue OUT
EXEC sp_OASetProperty @tar, 'CaptureXmlListing', @iValue
```

Controls whether extraction methods also capture an XML inventory of the archive. When set to `1`, methods such as `Untar`, `UntarGz`, `UntarBz2`, and `UntarZ` store the listing in `XmlListing`. The XML has the same structure as the string returned by `ListXml`. The default is `0`.

**Inspect without extracting:** Set `CaptureXmlListing` and `SuppressOutput` to `1` before an untar operation to scan the archive and obtain its XML listing without writing archive entries to disk.

### Tar.Charset

`Chilkat 11.7.0 · sqlserver · Tar · Charset · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'Charset', @sValue OUT
EXEC sp_OASetProperty @tar, 'Charset', @sValue
```

Specifies the character encoding used to decode filenames stored in a TAR archive during extraction. The default is `utf-8`, which is normally appropriate for modern archives.

This property affects archive entry names only. It does not convert or otherwise alter the contents of extracted files. TAR archives written by the `WriteTar*` methods store filenames as UTF-8.

**Filename interoperability:** The original TAR header format does not always identify the character encoding of a filename. Change this property only when an older archive is known to use a different encoding.

### Tar.DirMode

`Chilkat 11.7.0 · sqlserver · Tar · DirMode · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'DirMode', @iValue OUT
EXEC sp_OASetProperty @tar, 'DirMode', @iValue
```

Specifies the UNIX permission bits written to the TAR header for directory entries created by the `WriteTar*` methods. The default is octal `0755`, which represents `rwxr-xr-x`.

**Archive metadata:** This value records permissions in the archive. Whether the exact permissions are restored during extraction depends on the destination operating system, filesystem, process privileges, and local security policy.

### Tar.DirPrefix

`Chilkat 11.7.0 · sqlserver · Tar · DirPrefix · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'DirPrefix', @sValue OUT
EXEC sp_OASetProperty @tar, 'DirPrefix', @sValue
```

Specifies a path prefix to prepend to entries when a TAR archive is created. For example, setting this property to `subdir1` causes an entry such as `report.txt` to be stored as `subdir1/report.txt`.

The prefix changes only the path stored in the archive; it does not rename or move the source file on disk.

**AddFile2 exception:** `AddFile2` explicitly supplies the complete path within the archive, so `DirPrefix` is not applied to files added by that method.

### Tar.FileMode

`Chilkat 11.7.0 · sqlserver · Tar · FileMode · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'FileMode', @iValue OUT
EXEC sp_OASetProperty @tar, 'FileMode', @iValue
```

Specifies the UNIX permission bits written to the TAR header for ordinary file entries created by the `WriteTar*` methods. The default is octal `0644`, which represents `rw-r--r--`.

**Shell scripts:** Files recognized as shell scripts use `ScriptFileMode` instead, allowing executable permissions to be recorded separately.

### Tar.GroupId

`Chilkat 11.7.0 · sqlserver · Tar · GroupId · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'GroupId', @iValue OUT
EXEC sp_OASetProperty @tar, 'GroupId', @iValue
```

Specifies the numeric group identifier (GID) written to TAR headers when an archive is created. The default value is `1000`.

**Ownership metadata:** A stored GID is archive metadata. Restoring ownership may require elevated privileges and may be ignored or mapped differently on non-UNIX systems.

### Tar.GroupName

`Chilkat 11.7.0 · sqlserver · Tar · GroupName · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'GroupName', @sValue OUT
EXEC sp_OASetProperty @tar, 'GroupName', @sValue
```

Specifies the group name written to TAR headers when an archive is created. By default, Chilkat uses the username of the account running the application.

**Name versus numeric ID:** TAR headers can contain both a group name and the numeric `GroupId`. Extraction tools and operating systems may give different precedence to these fields.

### Tar.MatchCaseSensitive

`Chilkat 11.7.0 · sqlserver · Tar · MatchCaseSensitive · property · read/write · since 9.5.0.46`

```sql
EXEC sp_OAGetProperty @tar, 'MatchCaseSensitive', @iValue OUT
EXEC sp_OASetProperty @tar, 'MatchCaseSensitive', @iValue
```

Controls whether the patterns in `MustMatch` and `MustNotMatch` are matched case-sensitively. The default is `0`.

**Cross-platform behavior:** Case sensitivity in the archive filter is independent of whether the local filesystem itself treats filenames as case-sensitive.

### Tar.MustMatch

`Chilkat 11.7.0 · sqlserver · Tar · MustMatch · property · read/write · since 9.5.0.46`

```sql
EXEC sp_OAGetProperty @tar, 'MustMatch', @sValue OUT
EXEC sp_OASetProperty @tar, 'MustMatch', @sValue
```

Specifies an inclusion pattern applied when creating or extracting TAR archives, including compressed TAR formats. A candidate path is included or extracted only when it matches this pattern. The default is an empty string, which permits all paths.

The pattern may contain zero or more asterisks (`*`), where each asterisk matches zero or more characters. For example, `*.txt` selects paths ending in `.txt`. Case handling is controlled by `MatchCaseSensitive`.

**Combined filters:** If both `MustMatch` and `MustNotMatch` are set, a path must satisfy the inclusion pattern and must not satisfy the exclusion pattern.

### Tar.MustNotMatch

`Chilkat 11.7.0 · sqlserver · Tar · MustNotMatch · property · read/write · since 9.5.0.46`

```sql
EXEC sp_OAGetProperty @tar, 'MustNotMatch', @sValue OUT
EXEC sp_OASetProperty @tar, 'MustNotMatch', @sValue
```

Specifies an exclusion pattern applied when creating or extracting TAR archives, including compressed TAR formats. A candidate path that matches this pattern is skipped. The default is an empty string, which excludes nothing.

The pattern may contain zero or more asterisks (`*`), where each asterisk matches zero or more characters. For example, `*.obj` skips paths ending in `.obj`. Case handling is controlled by `MatchCaseSensitive`.

**Exclusion takes effect after inclusion:** When both filters are set, matching `MustMatch` does not override a match in `MustNotMatch`.

### Tar.NoAbsolutePaths

`Chilkat 11.7.0 · sqlserver · Tar · NoAbsolutePaths · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'NoAbsolutePaths', @iValue OUT
EXEC sp_OASetProperty @tar, 'NoAbsolutePaths', @iValue
```

Controls whether absolute archive paths are converted to relative paths during extraction. When `1`, a leading `/` or `\` is removed before the entry is written. The default is `1`.

**Recommended security setting:** Keep this property enabled when extracting archives you did not create. Also extract untrusted archives into a dedicated directory and inspect their entry names before relying on the extracted content.

### Tar.NumDirRoots

`Chilkat 11.7.0 · sqlserver · Tar · NumDirRoots · property · read-only`

```sql
EXEC sp_OAGetProperty @tar, 'NumDirRoots', @iValue OUT
```

Returns the number of directory roots currently registered for archive creation by calls to `AddDirRoot` and `AddDirRoot2`. Individual files added with `AddFile` or `AddFile2` are not included in this count.

Use zero-based indexes from `0` through `NumDirRoots - 1` with `GetDirRoot`.

### Tar.ScriptFileMode

`Chilkat 11.7.0 · sqlserver · Tar · ScriptFileMode · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'ScriptFileMode', @iValue OUT
EXEC sp_OASetProperty @tar, 'ScriptFileMode', @iValue
```

Specifies the UNIX permission bits written to TAR headers for shell-script files recognized by extensions such as `.sh`, `.csh`, `.bash`, and `.bsh`. The default is octal `0755`, which records executable permissions.

**Other files:** Non-script files use `FileMode`; directories use `DirMode`.

### Tar.SuppressOutput

`Chilkat 11.7.0 · sqlserver · Tar · SuppressOutput · property · read/write · since 9.5.0.46`

```sql
EXEC sp_OAGetProperty @tar, 'SuppressOutput', @iValue OUT
EXEC sp_OASetProperty @tar, 'SuppressOutput', @iValue
```

Controls whether untar operations write extracted files and directories to the filesystem. When `1`, methods such as `Untar`, `UntarGz`, `UntarBz2`, and `UntarZ` scan the archive without producing extracted output. The default is `0`.

**Archive inventory workflow:** Combine this property with `CaptureXmlListing` to obtain an XML listing without extracting the archive.

### Tar.UntarCaseSensitive

`Chilkat 11.7.0 · sqlserver · Tar · UntarCaseSensitive · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'UntarCaseSensitive', @iValue OUT
EXEC sp_OASetProperty @tar, 'UntarCaseSensitive', @iValue
```

**Deprecated.** Use `MatchCaseSensitive` instead.

Until this property is removed, reading or setting it has the same effect as reading or setting `MatchCaseSensitive`.

### Tar.UntarDebugLog

`Chilkat 11.7.0 · sqlserver · Tar · UntarDebugLog · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'UntarDebugLog', @iValue OUT
EXEC sp_OASetProperty @tar, 'UntarDebugLog', @iValue
```

Controls whether untar methods add per-entry extraction details to `LastErrorText`, `LastErrorXml`, and `LastErrorHtml`. The default is `0`.

**Diagnostic output is not necessarily an error:** When this property is enabled, the LastError properties can contain useful extraction trace information even after a successful operation.

### Tar.UntarDiscardPaths

`Chilkat 11.7.0 · sqlserver · Tar · UntarDiscardPaths · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'UntarDiscardPaths', @iValue OUT
EXEC sp_OASetProperty @tar, 'UntarDiscardPaths', @iValue
```

Controls whether directory components from archive entry names are discarded during extraction. When `1`, each file is written directly into `UntarFromDir` rather than recreating the archived directory tree. The default is `0`.

**Filename collisions:** Different archive entries can have the same final filename after their directory paths are removed. Use this option only when flattening the archive is intentional and potential collisions are acceptable.

### Tar.UntarFromDir

`Chilkat 11.7.0 · sqlserver · Tar · UntarFromDir · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'UntarFromDir', @sValue OUT
EXEC sp_OASetProperty @tar, 'UntarFromDir', @sValue
```

Specifies the destination directory for extraction. The default is `.`, meaning the current working directory of the calling process.

When `UntarDiscardPaths` is `0`, archived subdirectories are recreated beneath this directory. When it is `1`, extracted files are placed directly in this directory.

**Safer extraction:** For untrusted archives, choose a new or otherwise isolated destination directory rather than extracting directly into an application or system directory.

### Tar.UntarMaxCount

`Chilkat 11.7.0 · sqlserver · Tar · UntarMaxCount · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'UntarMaxCount', @iValue OUT
EXEC sp_OASetProperty @tar, 'UntarMaxCount', @iValue
```

Limits the number of matching entries extracted by an untar operation. The default is `0`, which means no maximum.

For example, set `MustMatch` to select a particular path and set `UntarMaxCount` to `1` to stop after the first matching entry is extracted.

**Archive order matters:** When a limit is used, extraction stops after the configured number of matches in archive order.

### Tar.UserId

`Chilkat 11.7.0 · sqlserver · Tar · UserId · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'UserId', @iValue OUT
EXEC sp_OASetProperty @tar, 'UserId', @iValue
```

Specifies the numeric user identifier (UID) written to TAR headers when an archive is created. The default value is `1000`.

**Ownership metadata:** A stored UID does not by itself change the owner of a local source file. Restoring ownership during extraction may require elevated privileges and may not apply on non-UNIX systems.

### Tar.UserName

`Chilkat 11.7.0 · sqlserver · Tar · UserName · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'UserName', @sValue OUT
EXEC sp_OASetProperty @tar, 'UserName', @sValue
```

Specifies the user name written to TAR headers when an archive is created. By default, Chilkat uses the username of the account running the application.

**Name versus numeric ID:** TAR headers can contain both a user name and the numeric `UserId`. Their interpretation depends on the extracting tool and destination system.

### Tar.WriteFormat

`Chilkat 11.7.0 · sqlserver · Tar · WriteFormat · property · read/write`

```sql
EXEC sp_OAGetProperty @tar, 'WriteFormat', @sValue OUT
EXEC sp_OASetProperty @tar, 'WriteFormat', @sValue
```

Specifies the TAR header format used by the `WriteTar*` methods. The default is `gnu`. Supported values are:

| Value | Use |
| :--- | :--- |
| `gnu` | GNU TAR format and extensions. This is the Chilkat default and supports archive metadata beyond classic ustar limits. |
| `pax` | POSIX pax extended format. It is designed to represent long names and additional metadata through extensible records. |
| `ustar` | POSIX ustar format. It is broadly interoperable but has stricter limits on path lengths and metadata fields. |

**Choosing a format:** Use `ustar` when compatibility with simple TAR readers is the priority and the archive fits its limits. Use `pax` for portable extended metadata, or retain `gnu` when GNU TAR compatibility is expected.

### Tar.XmlListing

`Chilkat 11.7.0 · sqlserver · Tar · XmlListing · property · read/write · since 9.5.0.46`

```sql
EXEC sp_OAGetProperty @tar, 'XmlListing', @sValue OUT
EXEC sp_OASetProperty @tar, 'XmlListing', @sValue
```

Contains the XML listing captured by the most recent untar operation for which `CaptureXmlListing` was `1`. The XML structure is the same as the output from `ListXml`.

**Read after the operation:** Use the untar method's return value to confirm that the archive was processed successfully before consuming this property.

## Methods

### Tar.AddDirRoot

`Chilkat 11.7.0 · sqlserver · Tar · AddDirRoot · method`

```sql
EXEC sp_OAMethod @tar, 'AddDirRoot', @success OUT, @dirPath
```

Adds the directory tree at `dirPath` to the set of sources used by the next `WriteTar*` operation. Call this method multiple times to include multiple directory trees in one archive.

Use `AddDirRoot2` when the tree should appear beneath an explicit prefix inside the archive.

**Queued archive sources:** Directory roots and files are retained by the object until `ClearDirRootsAndFiles` is called.

Returns 1 for success, 0 for failure.

### Tar.AddDirRoot2

`Chilkat 11.7.0 · sqlserver · Tar · AddDirRoot2 · method · since 9.5.0.56`

```sql
EXEC sp_OAMethod @tar, 'AddDirRoot2', @success OUT, @rootPrefix, @rootPath
```

Adds the directory tree at `rootPath` to the archive-creation source list and stores its entries beneath the archive prefix supplied in `rootPrefix`. Call this method multiple times, or combine it with `AddDirRoot`, before calling a `WriteTar*` method.

`rootPrefix` should be a relative archive path such as `abc/123` and should not end with `/`. If `DirPrefix` is also set, `DirPrefix` is applied first.

**Path composition example:** With `DirPrefix = "package"` and `rootPrefix = "assets"`, files from this root are stored beneath `package/assets/`.

Returns 1 for success, 0 for failure.

### Tar.AddFile

`Chilkat 11.7.0 · sqlserver · Tar · AddFile · method · since 9.5.0.46`

```sql
EXEC sp_OAMethod @tar, 'AddFile', @success OUT, @path
```

Adds the local file at `path` to the set of sources used by the next `WriteTar*` operation. Call `AddFile`, `AddFile2`, and the directory-root methods as needed before writing a single archive.

Use `AddFile2` when the path stored inside the TAR must be specified independently of the source file path.

**Queued archive sources:** Added files and directory roots remain associated with the object until `ClearDirRootsAndFiles` is called.

Returns 1 for success, 0 for failure.

### Tar.AddFile2

`Chilkat 11.7.0 · sqlserver · Tar · AddFile2 · method · since 9.5.0.69`

```sql
EXEC sp_OAMethod @tar, 'AddFile2', @success OUT, @filePath, @pathWithinTar
```

Adds the local file at `filePath` to the archive-creation source list and stores it using the exact archive path supplied in `pathWithinTar`. This allows the source path and the path visible inside the TAR to differ.

Call this method as many times as needed, optionally together with the other file and directory-root methods, before calling a single `WriteTar*` method.

**DirPrefix is not applied:** Because `pathWithinTar` already specifies the path within the TAR, `DirPrefix` does not modify entries added by this method. Use forward slashes and a relative path for portable archive names.

Returns 1 for success, 0 for failure.

### Tar.ClearDirRootsAndFiles

`Chilkat 11.7.0 · sqlserver · Tar · ClearDirRootsAndFiles · method · since 9.5.0.84`

```sql
EXEC sp_OAMethod @tar, 'ClearDirRootsAndFiles', @success OUT
```

Removes all files and directory roots previously registered by `AddDirRoot`, `AddDirRoot2`, `AddFile`, and `AddFile2`.

Call this method before building a different archive with the same `Tar` object when the earlier source list should not be reused.

Returns 1 for success, 0 for failure.

### Tar.CreateDeb

`Chilkat 11.7.0 · sqlserver · Tar · CreateDeb · method · since 9.5.0.66`

```sql
EXEC sp_OAMethod @tar, 'CreateDeb', @success OUT, @controlPath, @dataPath, @debPath
```

Creates a Debian binary package at `debPath` from the prepared control archive at `controlPath` and data archive at `dataPath`. The inputs are typically named `control.tar.gz` and `data.tar.gz`, or use another compression form accepted by the target Debian tooling.

**Debian package structure:** A modern `.deb` file is an `ar` archive containing a `debian-binary` format marker, a `control.tar.*` member for package metadata and maintainer scripts, and a `data.tar.*` member for the installed filesystem payload.

**Prepared inputs required:** This method packages the supplied control and data tarballs. The caller is responsible for making their directory layout, control metadata, permissions, and package contents valid for Debian package-management tools.

Returns 1 for success, 0 for failure.

### Tar.GetDirRoot

`Chilkat 11.7.0 · sqlserver · Tar · GetDirRoot · method`

```sql
EXEC sp_OAMethod @tar, 'GetDirRoot', @sResult OUT, @index
```

Returns a directory root previously added with `AddDirRoot` or `AddDirRoot2`. `index` is a zero-based index.

Valid indexes range from `0` through `NumDirRoots - 1`. For example, after two roots are added, `GetDirRoot(0)` returns the first and `GetDirRoot(1)` returns the second.

Returns `NULL` on failure

### Tar.ListXml

`Chilkat 11.7.0 · sqlserver · Tar · ListXml · method`

```sql
EXEC sp_OAMethod @tar, 'ListXml', @sResult OUT, @tarPath
```

Scans the uncompressed TAR archive at `tarPath` and returns an XML description of its files, directories, and archive metadata. The archive is not extracted.

**Compressed tarballs:** For a compressed TAR archive, an untar method can capture the same listing format by setting `CaptureXmlListing`. Set `SuppressOutput` as well when no files should be written.

Returns `NULL` on failure

### Tar.Untar

`Chilkat 11.7.0 · sqlserver · Tar · Untar · method`

```sql
EXEC sp_OAMethod @tar, 'Untar', @iResult OUT, @tarPath
```

Extracts the uncompressed TAR archive at `tarPath` into the directory specified by `UntarFromDir`. Archived directory trees are recreated unless `UntarDiscardPaths` is `1`.

Returns the number of files and directories extracted, or `-1` if the operation fails. Extraction is also affected by the matching, path-safety, count-limit, listing, and output-suppression properties of this object.

**TAR is a container format:** An ordinary `.tar` archive is not compressed. Use `UntarGz`, `UntarBz2`, or `UntarZ` for the corresponding compressed tarball formats.

### Tar.UntarBz2

`Chilkat 11.7.0 · sqlserver · Tar · UntarBz2 · method`

```sql
EXEC sp_OAMethod @tar, 'UntarBz2', @success OUT, @tarPath
```

Decompresses and extracts the `.tar.bz2` archive at `tarPath` into `UntarFromDir`. This format is also commonly named `.tbz`, `.tbz2`, or `.tb2`.

Returns `1` on success and `0` on failure. The same extraction filters, path controls, listing options, and output settings used by `Untar` also apply.

Returns 1 for success, 0 for failure.

### Tar.UntarFirstMatchingToBd

`Chilkat 11.7.0 · sqlserver · Tar · UntarFirstMatchingToBd · method · since 9.5.0.82`

```sql
EXEC sp_OAMethod @tar, 'UntarFirstMatchingToBd', @success OUT, @tarPath, @matchPattern, @bd
```

Scans the uncompressed TAR archive at `tarPath` and copies the contents of the first file whose archive path matches `matchPattern` into the `BinData` object supplied in `bd`. Matching is evaluated in archive order.

No archive entry is written to the local filesystem. Returns `1` when a matching file is successfully extracted to `bd` and `0` otherwise.

Returns 1 for success, 0 for failure.

### Tar.UntarGz

`Chilkat 11.7.0 · sqlserver · Tar · UntarGz · method`

```sql
EXEC sp_OAMethod @tar, 'UntarGz', @success OUT, @tarPath
```

Decompresses and extracts the `.tar.gz` archive at `tarPath` into `UntarFromDir`. The `.tgz` extension is a common short form for the same gzip-compressed TAR structure.

Returns `1` on success and `0` on failure. The same extraction filters, path controls, listing options, and output settings used by `Untar` also apply.

Returns 1 for success, 0 for failure.

### Tar.UntarZ

`Chilkat 11.7.0 · sqlserver · Tar · UntarZ · method`

```sql
EXEC sp_OAMethod @tar, 'UntarZ', @success OUT, @tarPath
```

Decompresses and extracts the `.tar.Z` archive at `tarPath` into `UntarFromDir`. The `.Z` suffix denotes the historical UNIX `compress` format; `.taz` is a common alternate extension.

Returns `1` on success and `0` on failure. The same extraction filters, path controls, listing options, and output settings used by `Untar` also apply.

Returns 1 for success, 0 for failure.

### Tar.VerifyTar

`Chilkat 11.7.0 · sqlserver · Tar · VerifyTar · method`

```sql
EXEC sp_OAMethod @tar, 'VerifyTar', @success OUT, @tarPath
```

Opens the uncompressed TAR archive at `tarPath` and scans its headers through the end of the archive. Returns `1` when the archive structure is accepted and no TAR-format errors are found; otherwise returns `0`.

**What verification does not establish:** Structural verification does not prove that archived files are safe, trustworthy, or appropriate to extract. It is not malware scanning and does not authenticate the archive publisher.

### Tar.WriteTar

`Chilkat 11.7.0 · sqlserver · Tar · WriteTar · method`

```sql
EXEC sp_OAMethod @tar, 'WriteTar', @success OUT, @tarPath
```

Creates an uncompressed TAR archive at `tarPath` from the files and directory trees previously added with `AddFile`, `AddFile2`, `AddDirRoot`, and `AddDirRoot2`. Archive paths, permissions, ownership metadata, filters, and header format are controlled by the corresponding properties.

Returns `1` on success and `0` on failure.

Returns 1 for success, 0 for failure.

### Tar.WriteTarBz2

`Chilkat 11.7.0 · sqlserver · Tar · WriteTarBz2 · method`

```sql
EXEC sp_OAMethod @tar, 'WriteTarBz2', @success OUT, @bz2Path
```

Creates a bzip2-compressed TAR archive at `bz2Path` from the files and directory trees previously added to this object. Common filename extensions include `.tar.bz2`, `.tbz`, `.tbz2`, and `.tb2`.

Returns `1` on success and `0` on failure.

**Two-layer format:** The result is a TAR byte stream compressed with bzip2. TAR supplies the multi-file archive structure; bzip2 supplies compression.

Returns 1 for success, 0 for failure.

### Tar.WriteTarGz

`Chilkat 11.7.0 · sqlserver · Tar · WriteTarGz · method`

```sql
EXEC sp_OAMethod @tar, 'WriteTarGz', @success OUT, @gzPath
```

Creates a gzip-compressed TAR archive at `gzPath` from the files and directory trees previously added to this object. The usual extensions are `.tar.gz` and `.tgz`.

Returns `1` on success and `0` on failure.

**Two-layer format:** The result is a TAR byte stream compressed with gzip. TAR supplies the multi-file archive structure; gzip supplies compression.

Returns 1 for success, 0 for failure.

## Events and callbacks

This binding has no event callbacks.

## Related classes

[`BinData`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/BinData.md)

