• Article

Use6xCompatible Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The Use6xCompatible property controls interpretation of Microsoft SQL Server bulk-copy native format data files.

Syntax

object.Use6xCompatible [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetUse6xCompatible(LPBOOL pRetVal);
HRESULT SetUse6xCompatible(BOOL NewValue);

Remarks

A SQL Server bulk-copy operation either creates or reads from a data file. SQL Server bulk-copy data files are created in either native (proprietary) or character format. SQL Server bulk-copy native data file format has changed for SQL Server version 7.0 and later. The user must direct version-dependent handling of source files when processing native format files created by SQL Server 7.0 or earlier.

If TRUE, a bulk-copy operation interprets file data based on the SQL Server 7.0 or earlier format for native data files.

If FALSE, default, a bulk-copy operation interprets file data based on the SQL Server 7.0 format.

Applies To:

BulkCopy Object