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]