Application 類別
Discovers and accesses Package objects. It can also access collections and properties that contain information about the system.
繼承階層
System. . :: . .Object
Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
Microsoft.SqlServer.Dts.Runtime..::..Application
命名空間: Microsoft.SqlServer.Dts.Runtime
組件: Microsoft.SqlServer.ManagedDTS (在 Microsoft.SqlServer.ManagedDTS.dll 中)
語法
'宣告
Public Class Application _
Inherits DtsObject
'用途
Dim instance As Application
public class Application : DtsObject
public ref class Application : public DtsObject
type Application =
class
inherit DtsObject
end
public class Application extends DtsObject
Application 型別公開下列成員。
屬性
名稱 | 說明 | |
---|---|---|
CheckSignatureOnLoad | Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package. | |
ComponentStorePath | Returns the path where pipeline components are stored. This property is read-only. | |
ConnectionInfos | Returns a ConnectionInfos collection that contains ConnectionInfo objects. This property is read-only. | |
DataTypeInfos | Returns a DataTypeInfos collection that contains DataTypeInfo objects. This property is read-only. | |
DBProviderInfos | Returns a DBProviderInfos collection that contains DBProviderInfo objects in the application. This property is read-only. | |
ForEachEnumeratorInfos | Returns a ForEachEnumeratorInfos collection that contains ForEachEnumeratorInfo objects. This property is read-only. | |
LogProviderInfos | Returns a LogProviderInfos collection that contains LogProviderInfo objects. This property is read-only. | |
PackagePassword | Sets the value of the password for the package. This property is write-only. | |
PackageUpgradeOptions | Gets or sets a value that indicates which upgrade options will be applied to a collection of Integration Services packages during the upgrade process. | |
PipelineComponentInfos | Returns a PipelineComponentInfos collection that contains PipelineComponentInfo objects. | |
TaskInfos | Returns a TaskInfos collection that contains TaskInfo objects. This property is read-only. | |
UpdateObjects | *** Member deprecated; see Remarks. *** Gets or sets a Boolean that indicates whether extensible objects can be updated at package load time if an updated version is found. | |
UpdatePackage | Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found. |
上層
方法
名稱 | 說明 | |
---|---|---|
CreateFolderOnDtsServer | Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. | |
CreateFolderOnSqlServer | Creates a folder on the specified instance of SQL Server. | |
DataTypeInfoFromDataType | Returns the DataTypeInfo object for the specified data type. | |
Equals | Determines whether two object instances are equal. (繼承自 DtsObject。) | |
ExistsOnDtsServer | Returns a Boolean that indicates whether the specified package already exists on the Integration Services service. | |
ExistsOnSqlServer | Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server. | |
Finalize | (繼承自 Object。) | |
FolderExistsOnDtsServer | Returns a Boolean that indicates whether the specified folder already exists on the file system. | |
FolderExistsOnSqlServer | Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server. | |
GetDtsServerPackageInfos | Gets a PackageInfos collection that contains the packages stored in the SSIS Package Store on an instance of SQL Server, within the specified folder. | |
GetDtsServerRoles | Returns an array of Strings that lists the roles available for a folder. | |
GetHashCode | Returns the hash code for this instance. (繼承自 DtsObject。) | |
GetPackageInfos | Gets a PackageInfos collection that contains the packages stored in an instance of SQL Server, within the specified logical folder, by using the server name, user name, and password. | |
GetPackageInfos2 | 基礎結構。 | |
GetPackageRoles | Returns the database roles that have read access and write access to the package. Database roles apply only to packages stored in the SQL Server msdb database. | |
GetRunningPackages | Returns a RunningPackages collection that contains RunningPackage objects. This property is read-only. | |
GetServerInfo | Returns the SQL Server version number of the SQL Server product installed on the target server. | |
GetServerVersionEx | Returns the edition, product level, and other values that indicate the version of SSIS installed. | |
GetType | (繼承自 Object。) | |
LoadFromDtsServer | Loads a package from the specified server. | |
LoadFromSqlServer | Loads a package from SQL Server by specifying the server name, user name, and password. | |
LoadFromSqlServer2 | 基礎結構。 | |
LoadPackage(String, IDTSEvents) | Loads a Package from the file system. | |
LoadPackage(String, IDTSEvents, Boolean) | Loads a Package from the file system, and specifies the threading model. | |
MemberwiseClone | (繼承自 Object。) | |
RemoveFolderFromDtsServer | Removes the specified folder from the specified server. | |
RemoveFolderFromSqlServer | Removes the specified folder from the specified instance of SQL Server. | |
RemoveFromDtsServer | Removes a package from the specified server. | |
RemoveFromSqlServer | Removes a package from the specified instance of SQL Server. | |
RenameFolderOnDtsServer | Renames a folder on the specified instance of SQL Server. | |
RenameFolderOnSqlServer | Renames a folder on the specified instance of SQL Server. | |
SaveToDtsServer | Saves a package to the file system. | |
SaveToSqlServer | Saves a package to an instance of SQL Server. | |
SaveToSqlServerAs | Saves a package to an instance of SQL Server with a new name. | |
SaveToXml | Saves the XML definition of a package to a file. | |
SetPackageRoles | Sets the database roles that have read access and write access to the package. Database roles apply only to package stored in the SQL Server msdb database. | |
ToString | (繼承自 Object。) | |
Upgrade | Upgrades one or more Integration Services packages from a specified source location to a specified destination location. |
上層
備註
The Application object is a system discovery and package access mechanism.
執行緒安全性
這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。