Application Class

Definition

发现并访问 Package 对象。Discovers and accesses Package objects. 它还可以访问包含有关系统的信息的集合和属性。It can also access collections and properties that contain information about the system.

public ref class Application : Microsoft::SqlServer::Dts::Runtime::DtsObject
public class Application : Microsoft.SqlServer.Dts.Runtime.DtsObject
type Application = class
    inherit DtsObject
Public Class Application
Inherits DtsObject
Inheritance
Application

Remarks

Application对象是系统发现和包访问机制。The Application object is a system discovery and package access mechanism.

Constructors

Application()

初始化 Application 类的新实例。Initializes a new instance of the Application class.

Properties

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

返回包含 ConnectionInfos 对象的 ConnectionInfo 集合。Returns a ConnectionInfos collection that contains ConnectionInfo objects. 此属性为只读。This property is read-only.

DataTypeInfos

返回包含 DataTypeInfos 对象的 DataTypeInfo 集合。Returns a DataTypeInfos collection that contains DataTypeInfo objects. 此属性为只读。This property is read-only.

DBProviderInfos

返回包含应用程序中的 DBProviderInfos 对象的 DBProviderInfo 集合。Returns a DBProviderInfos collection that contains DBProviderInfo objects in the application. 此属性为只读。This property is read-only.

DumpDescriptor

获取或设置应用程序的转储描述符。Gets or sets the dump descriptor for the application.

DumpOnAnyError

获取或设置应用程序在有任何错误时是否转储。Gets or sets whether the application dumps on any error.

EnableDump

获取或设置应用程序是否启用转储。Gets or sets whether the application enables dumping.

ForEachEnumeratorInfos

返回包含 ForEachEnumeratorInfos 对象的 ForEachEnumeratorInfo 集合。Returns a ForEachEnumeratorInfos collection that contains ForEachEnumeratorInfo objects. 此属性为只读。This property is read-only.

LogProviderInfos

返回包含 LogProviderInfos 对象的 LogProviderInfo 集合。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

获取或设置一个值,该值指示在升级过程中哪些升级选项将应用于 Integration Services 包的集合。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

返回包含 PipelineComponentInfos 对象的 PipelineComponentInfo 集合。Returns a PipelineComponentInfos collection that contains PipelineComponentInfo objects.

TargetServerVersion
TaskInfos

返回包含 TaskInfos 对象的 TaskInfo 集合。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.

Methods

CreateFolderOnDtsServer(String, String, String)

在 Integration Services 服务层次结构的“已存储的包”节点中显示的服务器上创建文件夹。Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy.

CreateFolderOnSqlServer(String, String, String, String, String)

在 SQL Server 的指定实例上创建文件夹。Creates a folder on the specified instance of SQL Server.

CreateSsisServerExecution(String, String, String, Boolean)

创建 SSIS 服务器执行。Creates SSIS server execution.

DataTypeInfoFromDataType(DataType)

为指定的数据类型返回 DataTypeInfo 对象。Returns the DataTypeInfo object for the specified data type.

Equals(Object)

确定两个对象实例是否相等。Determines whether two object instances are equal.

(Inherited from DtsObject)
ExistsOnDtsServer(String, String)

返回一个布尔值,该值指示指定的包在 Integration Services 服务上是否已存在。Returns a Boolean that indicates whether the specified package already exists on the Integration Services service.

ExistsOnSqlServer(String, String, String, String)

返回一个布尔值,该值指示指定的包在 SQL Server 的实例上是否存在。Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.

FolderExistsOnDtsServer(String, String)

返回一个布尔值,该值指示指定的文件夹在文件系统上是否已存在。Returns a Boolean that indicates whether the specified folder already exists on the file system.

FolderExistsOnSqlServer(String, String, String, String)

返回一个布尔值,该值指示指定的文件夹在 SQL Server 的实例上是否已存在。Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server.

GetDtsServerPackageInfos(String, String)

获取一个 PackageInfos 集合,该集合包含指定文件夹内 SQL Server 的实例上的 SSIS 包存储区中存储的包。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(String, String)

返回列出文件夹的可用角色的字符串数组。Returns an array of Strings that lists the roles available for a folder.

GetHashCode()

返回此实例的哈希代码。Returns the hash code for this instance.

(Inherited from DtsObject)
GetPackageInfos(String, String, String, String)

通过使用服务器名称、用户名和密码获取一个 PackageInfos 集合,该集合包含在指定的逻辑文件夹内 SQL Server 实例中存储的包。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(String, Object)

通过使用服务器名称、用户名和密码获取一个 PackageInfos 集合,该集合包含在指定的逻辑文件夹内 SQL Server 实例中存储的包。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.

GetPackageRoles(String, String, String, String)

返回对包具有读和写访问权限的数据库角色。Returns the database roles that have read access and write access to the package. 数据库角色仅适用于存储在 SQL Server msdb 数据库中的包。Database roles apply only to packages stored in the SQL Server msdb database.

GetRunningPackages(String)

返回包含 RunningPackages 对象的 RunningPackage 集合。Returns a RunningPackages collection that contains RunningPackage objects. 此属性为只读。This property is read-only.

GetServerInfo(String, String)

返回在目标服务器上安装的 SQL Server 产品的 SQL Server 版本号。Returns the SQL Server version number of the SQL Server product installed on the target server.

GetServerVersionEx(String, Int32, DTSProductLevel, String, String)

返回版本、产品级别和其他指示安装的 SSIS 版本的值。Returns the edition, product level, and other values that indicate the version of SSIS installed.

LoadFromDtsServer(String, String, IDTSEvents)

从指定的服务器加载包。Loads a package from the specified server.

LoadFromSqlServer(String, String, String, String, IDTSEvents)

通过指定服务器名称、用户名和密码从 SQL Server 加载包。Loads a package from SQL Server by specifying the server name, user name, and password.

LoadFromSqlServer2(String, Object, IDTSEvents)

通过指定服务器名称、用户名和密码从 SQL Server 加载包。Loads a package from SQL Server by specifying the server name, user name, and password.

LoadPackage(String, IDTSEvents)

从文件系统加载 PackageLoads a Package from the file system.

LoadPackage(String, IDTSEvents, Boolean)

从文件系统加载 Package 并指定线程模型。Loads a Package from the file system, and specifies the threading model.

RemoveFolderFromDtsServer(String, String)

从指定的服务器中删除指定的文件夹。Removes the specified folder from the specified server.

RemoveFolderFromSqlServer(String, String, String, String)

从指定的 SQL Server 实例中删除指定的文件夹。Removes the specified folder from the specified instance of SQL Server.

RemoveFromDtsServer(String, String)

从指定的服务器中删除包。Removes a package from the specified server.

RemoveFromSqlServer(String, String, String, String)

从指定的 SQL Server 实例中删除包。Removes a package from the specified instance of SQL Server.

RenameFolderOnDtsServer(String, String, String, String)

在 SQL Server 的指定实例上重命名文件夹。Renames a folder on the specified instance of SQL Server.

RenameFolderOnSqlServer(String, String, String, String, String, String)

在 SQL Server 的指定实例上重命名文件夹。Renames a folder on the specified instance of SQL Server.

SaveAndUpdateVersionToXml(String, Package, DTSTargetServerVersion, IDTSEvents)
SaveToDtsServer(Package, IDTSEvents, String, String)

将包保存到文件系统。Saves a package to the file system.

SaveToSqlServer(Package, IDTSEvents, String, String, String)

将包保存到 SQL Server 实例。Saves a package to an instance of SQL Server.

SaveToSqlServerAs(Package, IDTSEvents, String, String, String, String)

使用新名称将包保存到 SQL Server 实例。Saves a package to an instance of SQL Server with a new name.

SaveToXml(String, Package, IDTSEvents)

将包的 XML 定义保存到文件。Saves the XML definition of a package to a file.

SetPackageRoles(String, String, String, String)

设置对包具有读和写访问权限的数据库角色。Sets the database roles that have read access and write access to the package. 数据库角色仅适用于存储在 SQL Server msdb 数据库中的包。Database roles apply only to package stored in the SQL Server msdb database.

Upgrade(IEnumerable<UpgradePackageInfo>, StorageInfo, StorageInfo, BatchUpgradeOptions, IDTSEvents)

将一个或多个 Integration Services 包从指定的源位置升级到指定的目标位置。Upgrades one or more Integration Services packages from a specified source location to a specified destination location.

Applies to