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)
属性值
类型:Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask. . :: . .Exec80PackageTask. . :: . .Locations
A Exec80PackageTask..::..Locations value. The default value is SqlServer.
实现
注释
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.