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';"