DTS Programming

ErrorIfFileNotFound Property

The ErrorIfFileNotFound property specifies or returns a value indicating whether an error is raised if a file named by a source column does not exist.

Applies To

DataPumpTransformReadFile Object

Syntax

object.ErrorIfFileNotFound [= boolean]

Part	Description
object	Expression that evaluates to a DataPumpTransformReadFile object
boolean	Boolean that specifies whether an error is raised when the file named by a source column does not exist

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetErrorIfFileNotFound(VARIANT_BOOL* pRetVal);

HRESULT SetErrorIfFileNotFound(VARIANT_BOOL pRetVal);

Remarks

If FALSE, NULL is written to the destination column.

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

Set transprops = transform.TransformServerProperties
transprops("ErrorIfFileNotFound") [= boolean]