RepositoryDatabaseName Property
The RepositoryDatabaseName property sets or returns the name of the database that contains the instance of Microsoft® SQL Server™ 2000 Meta Data Services to be used by the ExecutePackageTask object.
Applies To
| ExecutePackageTask Object |
Syntax
object.RepositoryDatabaseName [= name]
| Part | Description |
|---|---|
| object | Expression that evaluates to an ExecutePackageTask object |
| name | Name of the database containing the instance of Meta Data Services |
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT RepositoryDatabaseName(BSTR* pRetVal);
HRESULT RepositoryDatabaseName(BSTR pRetVal);
Remarks
If RepositoryDatabaseName property is not provided, the default Meta Data Services database is used. RepositoryDatabaseName is also not needed if the Data Transformation Services (DTS) package to be run is in SQL Server storage or a data file.
This property also can be referenced through the Properties collection of the Task object with the following code:
Set taskprops = task.Properties
taskprops("RepositoryDatabaseName") [= password]