Exec80PackageTask.Location Property

Artikkeli
12/03/2008

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.

Namespace: Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask
Assembly: Microsoft.SqlServer.Exec80PackageTask (in microsoft.sqlserver.exec80packagetask.dll)

Syntax

'Declaration
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)

Property Value

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

Remarks

Updated text:5 December 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.

Thread Safety

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms