DTS Programming

FilePath Property

The FilePath property specifies or returns the path you want to prefix to the file name column in a custom transformation.

Applies To

DataPumpTransformReadFile Object

DataPumpTransformWriteFile Object

Syntax

object.FilePath [= string]

Part	Description
object	Expression that evaluates to an object in the Applies To list
string	Path to prefix to the file name column when it contains no path

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFilePath(BSTR* pRetVal);

HRESULT SetFilePath(BSTR pRetVal);

Remarks

"\" will be appended to the FilePath property, when necessary, to separate the path from the file name in the source column. If a value for FilePath is provided, the value will be prefixed to the file name even when it already includes a path.

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

Set transprops = transform.TransformServerProperties
transprops("FilePath") [= string]