Exec80PackageTask.Location Property

Gets or sets a Exec80PackageTask.Locations value that indicates the type of storage in which the Microsoft SQL Server 2000 Data Transformation Services (DTS) package to be executed by a Exec80PackageTask is located.

Пространство имен: Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask
Сборка: Microsoft.SqlServer.Exec80PackageTask (in microsoft.sqlserver.exec80packagetask.dll)

Синтаксис

'Декларация
Public Property Location As Locations

public Locations Location { get; set; }

public:
virtual property Locations Location {
    Locations get () sealed;
    void set (Locations value) sealed;
}

/** @property */
public final Locations get_Location ()

/** @property */
public final void set_Location (Locations value)

public final function get Location () : Locations

public final function set Location (value : Locations)

Значение свойства

A Exec80PackageTask.Locations value. The default value is SqlServer.

Замечания

Изменения текста5 декабря 2005 г.

Depending on the Location setting, different properties of the task are used. The following table lists the properties that are required and optional, depending on the value of Location.

Location	Properties
Exec80PackageTask.Locations.SqlServer	SQLServer, WindowsAuthentication, SQLUsername, SQLPassword, PackagePassword, PackageName, PackageID, PackageVersionGUID, InnerGlobalVariables.
Exec80PackageTask.Locations.StorageFile	Filename, PackagePassword, PackageName, PackageID, PackageVersionGUID, InnerGlobalVariables
Exec80PackageTask.Locations.EmbeddedInTask	Name, Description, PackageName, Location, SQLServer, WindowsAuthentication, SQLUsername, SQLPassword, PackagePassword, PackageName, PackageID, PackageVersionGUID, InnerGlobalVariables

The PackagePassword is used depending on the value of the ProtectionLevel. The SQLUsername and SQLPassword are used if the SQL Server is password protected.

Синхронизация потоков

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы