Condividi tramite


Membri Application

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

Il tipo Application espone i membri seguenti.

Costruttori

  Nome Descrizione
Metodo pubblico Application Initializes a new instance of the Application class.

In alto

Metodi

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

In alto

Proprietà

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

In alto