DTS Programming
SourceDataFileFileName Property
The SourceDataFileFileName property sets or returns a string that is the name and path of a file that contains the value to which a Data Transformation Services (DTS) package object property will be set by the DynamicPropertiesTask object, when the SourceType property is DTSDynamicPropertiesSourceType_DataFile.
Applies To
| DynamicPropertiesTaskAssignment Object |
Syntax
object.SourceDataFileFileName [= filespec]
| Part | Description |
|---|---|
| object | Expression that evaluates to a DynamicPropertiesTaskAssignment object |
| filespec | Name and path of file containing value to which a DTS package object property will be set |
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT SourceDataFileFileName(BSTR* pRetVal);
HRESULT SourceDataFileFileName(BSTR pRetVal);
Example
The following example sets the SourceDataFileName property to a file specification:
oAssign.SourceDataFileFileName = "C:\DTS_UE\TestData\PubsAuthors.txt"