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