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"