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

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

## Purpose

**Inspect metadata for a file, directory, symlink, or special item in an SFTP listing.**

`Chilkat.SFtpFile` represents one entry returned from an SFTP directory listing. It exposes the entry name, file type, size, ownership, permissions, timestamps, and server-provided attribute flags such as hidden, read-only, archive, immutable, encrypted, compressed, sparse, append-only, system, and synchronization status. It is typically used together with `Chilkat.SFtpDir` when iterating a remote directory and deciding how each entry should be displayed, filtered, downloaded, skipped, or processed.

**Name and type**

Read `Filename` and `FileType`, or use convenience flags such as `IsRegular`, `IsDirectory`, and `IsSymLink`.

**File sizes**

Access the entry size as a 32-bit integer, 64-bit integer, or decimal string using `Size32`, `Size64`, or `SizeStr`.

**Timestamps**

Inspect creation, last-access, and last-modified times as date/time values or RFC822-formatted strings when supported by the server.

**Ownership**

Read numeric user and group IDs, and when the server supports it, textual owner and group names.

**Permissions**

Inspect the POSIX-style permissions bit mask for read, write, execute, set-user-ID, set-group-ID, and sticky-bit information.

**Extended attributes**

Check server-provided flags such as hidden, read-only, archive, immutable, encrypted, compressed, sparse, append-only, system, and sync.

**Common pattern:** Retrieve a directory listing with `Chilkat.SFtp`, iterate its `Chilkat.SFtpDir` entries, and populate a `Chilkat.SFtpFile` object for each item. Use the file type, timestamps, size, permissions, and attribute flags to decide whether the entry is a regular file, directory, symlink, or special item and how the application should handle it.

**Server-version note:** Some metadata is only available from newer SFTP protocol versions. For example, textual owner/group information and creation time require SFTP v4 or later, while many extended attribute flags such as read-only, archive, immutable, compressed, encrypted, sparse, append-only, and system require SFTP v6 or later.

## Object creation, unlocking and error handling

**Object Creation**

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

-- ... use @sFtpFile ...

EXEC @hr = sp_OADestroy @sFtpFile
```

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.SFtpFile.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 @sFtpFile, '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 @sFtpFile, 'DebugLogFilePath', @sValue OUT EXEC sp_OASetProperty @sFtpFile, '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 @sFtpFile, '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 @sFtpFile, 'LastErrorHtml', @sValue OUT` | read-only | Provides HTML-formatted information about the last called method or property. |
| `LastErrorText` | `EXEC sp_OAGetProperty @sFtpFile, 'LastErrorText', @sValue OUT` | read-only | Provides plain text information about the last called method or property. |
| `LastErrorXml` | `EXEC sp_OAGetProperty @sFtpFile, 'LastErrorXml', @sValue OUT` | read-only | Provides XML-formatted information about the last called method or property. |
| `LastMethodSuccess` | `EXEC sp_OAGetProperty @sFtpFile, 'LastMethodSuccess', @iValue OUT EXEC sp_OASetProperty @sFtpFile, '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 @sFtpFile, '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 @sFtpFile, 'LastStringResultLen', @iValue OUT` | read-only | The length, in characters, of the string contained in the LastStringResult property. |
| `VerboseLogging` | `EXEC sp_OAGetProperty @sFtpFile, 'VerboseLogging', @iValue OUT EXEC sp_OASetProperty @sFtpFile, '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 @sFtpFile, 'Version', @sValue OUT` | read-only | Version of the component/library, such as "10.1.0" |

## Member index

| Member | Kind | Signature |
|---|---|---|
| `CreateTime` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'CreateTime', @dtValue OUT` |
| `CreateTimeStr` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'CreateTimeStr', @sValue OUT` |
| `Filename` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'Filename', @sValue OUT` |
| `FileType` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'FileType', @sValue OUT` |
| `Gid` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'Gid', @iValue OUT` |
| `Group` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'Group', @sValue OUT` |
| `IsAppendOnly` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsAppendOnly', @iValue OUT` |
| `IsArchive` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsArchive', @iValue OUT` |
| `IsCaseInsensitive` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsCaseInsensitive', @iValue OUT` |
| `IsCompressed` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsCompressed', @iValue OUT` |
| `IsDirectory` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsDirectory', @iValue OUT` |
| `IsEncrypted` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsEncrypted', @iValue OUT` |
| `IsHidden` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsHidden', @iValue OUT` |
| `IsImmutable` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsImmutable', @iValue OUT` |
| `IsReadOnly` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsReadOnly', @iValue OUT` |
| `IsRegular` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsRegular', @iValue OUT` |
| `IsSparse` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsSparse', @iValue OUT` |
| `IsSymLink` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsSymLink', @iValue OUT` |
| `IsSync` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsSync', @iValue OUT` |
| `IsSystem` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'IsSystem', @iValue OUT` |
| `LastAccessTime` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'LastAccessTime', @dtValue OUT` |
| `LastAccessTimeStr` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'LastAccessTimeStr', @sValue OUT` |
| `LastModifiedTime` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'LastModifiedTime', @dtValue OUT` |
| `LastModifiedTimeStr` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'LastModifiedTimeStr', @sValue OUT` |
| `Owner` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'Owner', @sValue OUT` |
| `Permissions` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'Permissions', @iValue OUT` |
| `Size32` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'Size32', @iValue OUT` |
| `SizeStr` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'SizeStr', @sValue OUT` |
| `Uid` | property, read-only | `EXEC sp_OAGetProperty @sFtpFile, 'Uid', @iValue OUT` |

Deprecated members are listed at the end of this file with their replacements; do not use them in new code.

## Properties

### SFtpFile.CreateTime

`Chilkat 11.7.0 · sqlserver · SFtpFile · CreateTime · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'CreateTime', @dtValue OUT
```

Returns the file creation date and time as a native date/time value.

**Server requirement:** Creation-time metadata is available only when the server supports SFTP version 4 or later and provides this attribute.

### SFtpFile.CreateTimeStr

`Chilkat 11.7.0 · sqlserver · SFtpFile · CreateTimeStr · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'CreateTimeStr', @sValue OUT
```

Returns the file creation date and time as an RFC 822-formatted string, such as `Fri, 21 Nov 1997 09:55:06 -0600`.

**Server requirement:** Creation-time metadata is available only when the server supports SFTP version 4 or later and provides this attribute.

### SFtpFile.Filename

`Chilkat 11.7.0 · sqlserver · SFtpFile · Filename · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'Filename', @sValue OUT
```

Returns the name of the directory entry. Depending on the entry type, this may be a regular filename, directory name, symbolic-link name, or the name of another special filesystem object.

### SFtpFile.FileType

`Chilkat 11.7.0 · sqlserver · SFtpFile · FileType · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'FileType', @sValue OUT
```

Identifies the type of directory entry. The returned value is one of the following:

| Value | Meaning |
| :--- | :--- |
| `regular` | A regular file. |
| `directory` | A directory. |
| `symLink` | A symbolic link. |
| `special` | A special file whose more specific type is not reported. |
| `unknown` | The type is unknown or was not provided by the server. |
| `socket` | A socket. |
| `charDevice` | A character device. |
| `blockDevice` | A block device. |
| `fifo` | A FIFO (named pipe). |

The convenience properties `IsRegular`, `IsDirectory`, and `IsSymLink` may be used for the most common entry types.

### SFtpFile.Gid

`Chilkat 11.7.0 · sqlserver · SFtpFile · Gid · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'Gid', @iValue OUT
```

Returns the numeric group ID associated with the file.

### SFtpFile.Group

`Chilkat 11.7.0 · sqlserver · SFtpFile · Group · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'Group', @sValue OUT
```

Returns the textual group name associated with the file.

**Server requirement:** This attribute is available only when the server supports SFTP version 4 or later and provides owner/group names.

### SFtpFile.IsAppendOnly

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsAppendOnly · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsAppendOnly', @iValue OUT
```

Returns `1` if the server marks the file as append-only. New data may be added only at the end of the file; existing data cannot be overwritten through normal file writes.

**Server requirement:** This attribute is defined for SFTP version 6 or later.

### SFtpFile.IsArchive

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsArchive · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsArchive', @iValue OUT
```

Returns `1` if the server marks the file for inclusion in backup or archive operations.

**Server requirement:** This attribute is defined for SFTP version 6 or later.

### SFtpFile.IsCaseInsensitive

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsCaseInsensitive · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsCaseInsensitive', @iValue OUT
```

Applies to directories. Returns `1` when names within the directory should be compared without regard to letter case.

**Server requirement:** This attribute is defined for SFTP version 6 or later.

### SFtpFile.IsCompressed

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsCompressed · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsCompressed', @iValue OUT
```

Returns `1` if the file is stored using transparent filesystem-level compression on the server.

This attribute describes how the server stores the file. It does not change the file bytes transferred through SFTP.

**Server requirement:** This attribute is defined for SFTP version 6 or later.

### SFtpFile.IsDirectory

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsDirectory · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsDirectory', @iValue OUT
```

Returns `1` if the directory entry is a directory.

### SFtpFile.IsEncrypted

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsEncrypted · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsEncrypted', @iValue OUT
```

Returns `1` if the file is stored using transparent filesystem-level encryption on the server.

This attribute describes storage at rest. It does not alter the file bytes returned by read operations or accepted by write operations.

**Server requirement:** This attribute is defined for SFTP version 6 or later.

### SFtpFile.IsHidden

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsHidden · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsHidden', @iValue OUT
```

Returns `1` if the server marks the entry as hidden. Hidden entries are normally omitted from user-facing displays unless the user specifically requests them.

### SFtpFile.IsImmutable

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsImmutable · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsImmutable', @iValue OUT
```

Returns `1` if the server marks the file as immutable. An immutable file cannot normally be deleted, renamed, modified, or used as the target of a new hard link.

Immutability is generally stronger than read-only status, the ordinary permission mask, or an access-control list. On many systems, only a privileged administrator can set or clear this attribute.

**Server requirement:** This attribute is defined for SFTP version 6 or later.

### SFtpFile.IsReadOnly

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsReadOnly · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsReadOnly', @iValue OUT
```

Returns `1` if the server marks the file as read-only.

**Server requirement:** This attribute is defined for SFTP version 6 or later.

### SFtpFile.IsRegular

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsRegular · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsRegular', @iValue OUT
```

Returns `1` if the directory entry is a regular file rather than a directory, symbolic link, device, socket, FIFO, or other special type.

### SFtpFile.IsSparse

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsSparse · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsSparse', @iValue OUT
```

Returns `1` if the server identifies the file as sparse. A sparse file can contain unwritten regions, often called holes, that read as zero bytes without consuming equivalent physical disk space.

For example, writing data at an offset of 10 MB may leave the region between the previous end of file and that offset unallocated on disk.

Some servers store all files sparsely and may always set this flag. Other servers cannot reliably determine whether a file is sparse, so a file may be sparse even when this property is `0`.

**Server requirement:** This attribute is defined for SFTP version 6 or later.

### SFtpFile.IsSymLink

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsSymLink · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsSymLink', @iValue OUT
```

Returns `1` if the directory entry is a symbolic link.

### SFtpFile.IsSync

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsSync · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsSync', @iValue OUT
```

Returns `1` if modifications to the file are committed synchronously to server storage.

**Server requirement:** This attribute is defined for SFTP version 6 or later.

### SFtpFile.IsSystem

`Chilkat 11.7.0 · sqlserver · SFtpFile · IsSystem · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'IsSystem', @iValue OUT
```

Returns `1` if the server marks the file as part of the operating system.

**Server requirement:** This attribute is defined for SFTP version 6 or later.

### SFtpFile.LastAccessTime

`Chilkat 11.7.0 · sqlserver · SFtpFile · LastAccessTime · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'LastAccessTime', @dtValue OUT
```

Returns the file's last-access date and time as a native date/time value.

### SFtpFile.LastAccessTimeStr

`Chilkat 11.7.0 · sqlserver · SFtpFile · LastAccessTimeStr · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'LastAccessTimeStr', @sValue OUT
```

Returns the file's last-access date and time as an RFC 822-formatted string, such as `Fri, 21 Nov 1997 09:55:06 -0600`.

### SFtpFile.LastModifiedTime

`Chilkat 11.7.0 · sqlserver · SFtpFile · LastModifiedTime · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'LastModifiedTime', @dtValue OUT
```

Returns the file's last-modified date and time as a native date/time value.

### SFtpFile.LastModifiedTimeStr

`Chilkat 11.7.0 · sqlserver · SFtpFile · LastModifiedTimeStr · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'LastModifiedTimeStr', @sValue OUT
```

Returns the file's last-modified date and time as an RFC 822-formatted string, such as `Fri, 21 Nov 1997 09:55:06 -0600`.

Use `LastModifiedTime` when a native date/time value is more convenient.

### SFtpFile.Owner

`Chilkat 11.7.0 · sqlserver · SFtpFile · Owner · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'Owner', @sValue OUT
```

Returns the textual owner name associated with the file.

**Server requirement:** This attribute is available only when the server supports SFTP version 4 or later and provides owner/group names.

### SFtpFile.Permissions

`Chilkat 11.7.0 · sqlserver · SFtpFile · Permissions · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'Permissions', @iValue OUT
```

Returns the POSIX-style file-permission bit mask. The values correspond to the permission and special-mode bits in the POSIX `st_mode` field.

| Symbol | Octal value | Meaning |
| :--- | :--- | :--- |
| `S_IRUSR` | `0400` | Owner read |
| `S_IWUSR` | `0200` | Owner write |
| `S_IXUSR` | `0100` | Owner execute |
| `S_IRGRP` | `0040` | Group read |
| `S_IWGRP` | `0020` | Group write |
| `S_IXGRP` | `0010` | Group execute |
| `S_IROTH` | `0004` | Others read |
| `S_IWOTH` | `0002` | Others write |
| `S_IXOTH` | `0001` | Others execute |
| `S_ISUID` | `4000` | Set-user-ID |
| `S_ISGID` | `2000` | Set-group-ID |
| `S_ISVTX` | `1000` | Sticky bit |

Use bitwise AND operations to test individual permission bits.

### SFtpFile.Size32

`Chilkat 11.7.0 · sqlserver · SFtpFile · Size32 · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'Size32', @iValue OUT
```

Returns the file size in bytes as a 32-bit integer. Returns `-1` when the size cannot be represented by a 32-bit integer. Use `Size64` or `SizeStr` for larger values.

### SFtpFile.SizeStr

`Chilkat 11.7.0 · sqlserver · SFtpFile · SizeStr · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'SizeStr', @sValue OUT
```

Returns the file size in bytes as a base-10 string. This is the string representation of `Size64` and is useful in environments where a 64-bit integer is inconvenient or unavailable.

### SFtpFile.Uid

`Chilkat 11.7.0 · sqlserver · SFtpFile · Uid · property · read-only`

```sql
EXEC sp_OAGetProperty @sFtpFile, 'Uid', @iValue OUT
```

Returns the numeric user ID associated with the file.

## Deprecated members — do not use in new code

| Member | Kind | Deprecated in | Use instead |
|---|---|---|---|
| `GetCreateDt` | method | before 11.6.1 | — |
| `GetLastAccessDt` | method | before 11.6.1 | — |
| `GetLastModifiedDt` | method | before 11.6.1 | — |

