SourceFilename Property

DTS Programming

DTS Programming

SourceFilename Property

The SourceFilename property sets or returns a list of files, with path and size, to be transferred from the source by a DTSFTPTask object.

Applies To
DTSFTPTask Object
Syntax

object.SourceFilename [= 'name';'path';'size';'name';'path';'size'; ...]

Part Description
object Expression that evaluates to a DTSFTPTask object
name Name of file to be transferred from the source
path Path of file specified by name
size Size of file specified by name and path

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT SourceFilename(BSTR* pVal);

HRESULT SourceFilename(BSTR pVal);

Remarks

If a path or site is specified by the SourceSite property, the path from the SourceFilename list is appended to the SourceSite property, and this value is used as the full path.

The size field is used by Data Transformation Services (DTS) Designer. It is not necessary to provide a size value when referencing the SourceFilename property programmatically. However, the enclosing apostrophes should still be coded.

The property also can be referenced through the Properties collection of the Task object with the following code:

Set taskprops = task.Properties
taskprops("SourceFilename") [= list]

Example

The following example sets the SourceFilename property to a list of two file names:

    oCustTask.SourceFilename = _
            "'File3.dat';'';'123';'NWProdWiz.xls';'';'458240';"

See Also

SourceLocation Property

SourcePassword (DTSFTPTask) Property

SourceSite Property

SourceUsername Property