Compartir a través de

  • Artículo

Location Propiedad

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.

Espacio de nombres:  Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask
Ensamblado:  Microsoft.SqlServer.Exec80PackageTask (en Microsoft.SqlServer.Exec80PackageTask.dll)

Sintaxis

'Declaración
Public Property Location As Exec80PackageTask..::..Locations
    Get
    Set
'Uso
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)

Implementa

IDTSExec80PackageTask. . :: . .Location

Comentarios

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.