DTS Programming

AppendIfFileExists Property

The AppendIfFileExists property specifies or returns a value indicating whether data written to a destination file is appended to or is written over data that was present when the file was opened.

Applies To

DataPumpTransformWriteFile Object

Syntax

object.AppendIfFileExists [= boolean]

Part	Description
object	Expression that evaluates to a DataPumpTransformWriteFile object.
boolean	If TRUE, data is appended to data that already exists in the file. If FALSE, existing data is overwritten.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT AppendIfFileExists(VARIANT_BOOL* pRetVal);

HRESULT AppendIfFileExists(VARIANT_BOOL pRetVal);

Remarks

The property also can be referenced through the TransformServerProperties collection with the following code:

Set transprops = transform.TransformServerProperties
transprops"AppendIfFileExists") [= boolean]