FileName Property
The FileName property sets or returns the name and path of the file that contains a Data Transformation Services (DTS) package to be run by an Execute Package Task object.
Applies To
| ExecutePackageTask Object |
Syntax
object.FileName [= filespec]
| Part | Description |
|---|---|
| object | Expression that evaluates to an ExecutePackageTask object |
| filespec | Name and path of the file that contains the package |
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetFileName(BSTR* pRetVal);
HRESULT SetFileName(BSTR pRetVal);
Remarks
If the FileName property is empty, the ExecutePackageTask object looks in Microsoft® SQL Server™ 2000 Meta Data Services or in the SQL Server msdb database (depending on the setting of the UseRepository property) on the specified server to find the package to be run.
This property also can be referenced through the Properties collection of the Task object with the following code:
Set taskprops = task.Properties
taskprops("FileName") [= filespec]
Example
The following example assigns a file specification to the FileName property:
objCustTask.FileName = "C:\DTS_UE\TestPkg\WriteFileTest.dts"