Partilhar via

  • Artigo

Membros Application

Discovers and accesses Package objects. It can also access collections and properties that contain information about the system.

O tipo Application expõe os seguintes membros.

Construtores

  Nome Descrição
Método público Application Initializes a new instance of the Application class.

Início

Métodos

  Nome Descrição
Método público CreateFolderOnDtsServer Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy.
Método público CreateFolderOnSqlServer Creates a folder on the specified instance of SQL Server.
Método público DataTypeInfoFromDataType Returns the DataTypeInfo object for the specified data type.
Método público Equals Determines whether two object instances are equal. (Herdado de DtsObject.)
Método público ExistsOnDtsServer Returns a Boolean that indicates whether the specified package already exists on the Integration Services service.
Método público ExistsOnSqlServer Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.
Método protegido Finalize (Herdado de Object.)
Método público FolderExistsOnDtsServer Returns a Boolean that indicates whether the specified folder already exists on the file system.
Método público FolderExistsOnSqlServer Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server.
Método público 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.
Método público GetDtsServerRoles Returns an array of Strings that lists the roles available for a folder.
Método público GetHashCode Returns the hash code for this instance. (Herdado de DtsObject.)
Método público 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.
Método público GetPackageInfos2 Infraestrutura.
Método público 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.
Método público GetRunningPackages Returns a RunningPackages collection that contains RunningPackage objects. This property is read-only.
Método público GetServerInfo Returns the SQL Server version number of the SQL Server product installed on the target server.
Método público GetServerVersionEx Returns the edition, product level, and other values that indicate the version of SSIS installed.
Método público GetType (Herdado de Object.)
Método público LoadFromDtsServer Loads a package from the specified server.
Método público LoadFromSqlServer Loads a package from SQL Server by specifying the server name, user name, and password.
Método público LoadFromSqlServer2 Infraestrutura.
Método público LoadPackage(String, IDTSEvents) Loads a Package from the file system.
Método público LoadPackage(String, IDTSEvents, Boolean) Loads a Package from the file system, and specifies the threading model.
Método protegido MemberwiseClone (Herdado de Object.)
Método público RemoveFolderFromDtsServer Removes the specified folder from the specified server.
Método público RemoveFolderFromSqlServer Removes the specified folder from the specified instance of SQL Server.
Método público RemoveFromDtsServer Removes a package from the specified server.
Método público RemoveFromSqlServer Removes a package from the specified instance of SQL Server.
Método público RenameFolderOnDtsServer Renames a folder on the specified instance of SQL Server.
Método público RenameFolderOnSqlServer Renames a folder on the specified instance of SQL Server.
Método público SaveToDtsServer Saves a package to the file system.
Método público SaveToSqlServer Saves a package to an instance of SQL Server.
Método público SaveToSqlServerAs Saves a package to an instance of SQL Server with a new name.
Método público SaveToXml Saves the XML definition of a package to a file.
Método público 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.
Método público ToString (Herdado de Object.)
Método público Upgrade Upgrades one or more Integration Services packages from a specified source location to a specified destination location.

Início

Propriedades

  Nome Descrição
Propriedade pública CheckSignatureOnLoad Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package.
Propriedade pública ComponentStorePath Returns the path where pipeline components are stored. This property is read-only.
Propriedade pública ConnectionInfos Returns a ConnectionInfos collection that contains ConnectionInfo objects. This property is read-only.
Propriedade pública DataTypeInfos Returns a DataTypeInfos collection that contains DataTypeInfo objects. This property is read-only.
Propriedade pública DBProviderInfos Returns a DBProviderInfos collection that contains DBProviderInfo objects in the application. This property is read-only.
Propriedade pública ForEachEnumeratorInfos Returns a ForEachEnumeratorInfos collection that contains ForEachEnumeratorInfo objects. This property is read-only.
Propriedade pública LogProviderInfos Returns a LogProviderInfos collection that contains LogProviderInfo objects. This property is read-only.
Propriedade pública PackagePassword Sets the value of the password for the package. This property is write-only.
Propriedade pública 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.
Propriedade pública PipelineComponentInfos Returns a PipelineComponentInfos collection that contains PipelineComponentInfo objects.
Propriedade pública TaskInfos Returns a TaskInfos collection that contains TaskInfo objects. This property is read-only.
Propriedade pública 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.
Propriedade pública UpdatePackage Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found.

Início