DTS Programming

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]