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.
Namespace: Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask
Assembly: Microsoft.SqlServer.Exec80PackageTask (in Microsoft.SqlServer.Exec80PackageTask.dll)
Syntax
'Declaration
Public Property Location As Exec80PackageTask..::..Locations
Get
Set
'Usage
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)
Property Value
Type: Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.Locations
A Exec80PackageTask.Locations value. The default value is SqlServer.
Implements
Remarks
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.
See Also