Location 属性

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(在 Microsoft.SqlServer.Exec80PackageTask.dll 中)

语法

声明
Public Property Location As Exec80PackageTask..::..Locations
    Get
    Set
用法
Dim instance As Exec80PackageTask
Dim value As Exec80PackageTask..::..Locations

value = instance.Location

instance.Location = value
public Exec80PackageTask..::..Locations Location { get; set; }
public:
virtual property Exec80PackageTask..::..Locations Location {
    Exec80PackageTask..::..Locations get () sealed;
    void set (Exec80PackageTask..::..Locations value) sealed;
}
abstract Location : Exec80PackageTask..::..Locations with get, set
override Location : Exec80PackageTask..::..Locations with get, set
final function get Location () : Exec80PackageTask..::..Locations
final function set Location (value : Exec80PackageTask..::..Locations)

实现

IDTSExec80PackageTask. . :: . .Location

注释

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.