Partager via

  • Article

Location propriété

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.

Espace de noms :  Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask
Assembly :  Microsoft.SqlServer.Exec80PackageTask (dans Microsoft.SqlServer.Exec80PackageTask.dll)

Syntaxe

'Déclaration
Public Property Location As Exec80PackageTask..::..Locations
    Get
    Set
'Utilisation
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)

Implémente

IDTSExec80PackageTask. . :: . .Location

Notes

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.