DMQueryTask.OverwriteOutputTable Property

Artigo
12/03/2008

Gets or sets the Boolean value that indicates if the prediction query should overwrite content in the destination table.

Namespace: Microsoft.SqlServer.Dts.Tasks.DMQueryTask
Assembly: Microsoft.SqlServer.DMQueryTask (in microsoft.sqlserver.dmquerytask.dll)

Syntax

'Declaration
Public Property OverwriteOutputTable As Boolean

public bool OverwriteOutputTable { get; set; }

public:
virtual property bool OverwriteOutputTable {
    bool get () sealed;
    void set (bool value) sealed;
}

/** @property */
public final boolean get_OverwriteOutputTable ()

/** @property */
public final void set_OverwriteOutputTable (boolean value)

public final function get OverwriteOutputTable () : boolean

public final function set OverwriteOutputTable (value : boolean)

Property Value

true to overwrite the content in the destination table; false to append the results to the existing results.

Remarks

If the value of the property is False, and the schema of the output table does not match the schema of the result query, an insertion error is raised.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Partilhar via