Application Members

  • Article

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

The following tables list the members exposed by the Application type.

Public Constructors

  Name Description
Application Initializes a new instance of the Application class.

Top

Public Properties

  Name Description
ms211654.pubproperty(en-US,SQL.90).gif CheckSignatureOnLoad Gets or sets a Boolean that indicates whether a Package object should check the signature when loading.
ms211654.pubproperty(en-US,SQL.90).gif ComponentStorePath Returns the path where pipeline components are stored. This property is read-only.
ms211654.pubproperty(en-US,SQL.90).gif ConnectionInfos Returns a ConnectionInfos collection that contains ConnectionInfo objects. This property is read-only.
ms211654.pubproperty(en-US,SQL.90).gif DataTypeInfos Returns a DataTypeInfos collection that contains DataTypeInfo objects. This property is read-only.
ms211654.pubproperty(en-US,SQL.90).gif DBProviderInfos Returns a DBProviderInfos collection that contains DBProviderInfo objects in the application. This property is read-only.
ms211654.pubproperty(en-US,SQL.90).gif ForEachEnumeratorInfos Returns a ForEachEnumeratorInfos collection that contains ForEachEnumeratorInfo objects. This property is read-only.
ms211654.pubproperty(en-US,SQL.90).gif LogProviderInfos Returns a LogProviderInfos collection that contains LogProviderInfo objects. This property is read-only.
ms211654.pubproperty(en-US,SQL.90).gif PackagePassword Sets the value of the password for the package. This property is write-only.
ms211654.pubproperty(en-US,SQL.90).gif PipelineComponentInfos Returns a PipelineComponentInfos collection that contains PipelineComponentInfo objects.
ms211654.pubproperty(en-US,SQL.90).gif TaskInfos Returns a TaskInfos collection that contains TaskInfo objects. This property is read-only.
ms211654.pubproperty(en-US,SQL.90).gif UpdateObjects Gets or sets a Boolean that indicates whether extensible objects can be updated at package load time if an updated version is found.
ms211654.pubproperty(en-US,SQL.90).gif UpdatePackage Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms211654.pubmethod(en-US,SQL.90).gif CreateFolderOnDtsServer Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy.
ms211654.pubmethod(en-US,SQL.90).gif CreateFolderOnSqlServer Creates a folder on the specified instance of SQL Server.
ms211654.pubmethod(en-US,SQL.90).gif DataTypeInfoFromDataType Returns the DataTypeInfo object for the specified data type. This method is not CLS-compliant.
ms211654.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms211654.pubmethod(en-US,SQL.90).gif ExistsOnDtsServer Returns a Boolean that indicates whether the specified package already exists on the Integration Services service.
ms211654.pubmethod(en-US,SQL.90).gif ExistsOnSqlServer Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.
ms211654.pubmethod(en-US,SQL.90).gif FolderExistsOnDtsServer Returns a Boolean that indicates whether the specified folder already exists on the file system.
ms211654.pubmethod(en-US,SQL.90).gif FolderExistsOnSqlServer Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server.
ms211654.pubmethod(en-US,SQL.90).gif 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.
ms211654.pubmethod(en-US,SQL.90).gif GetDtsServerRoles Returns an array of Strings that lists the roles available for a folder.
ms211654.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms211654.pubmethod(en-US,SQL.90).gif 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.
ms211654.pubmethod(en-US,SQL.90).gif GetPackageInfos2  
ms211654.pubmethod(en-US,SQL.90).gif 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 Servermsdb database.
ms211654.pubmethod(en-US,SQL.90).gif GetRunningPackages Returns a RunningPackages collection that contains RunningPackage objects. This property is read-only.
ms211654.pubmethod(en-US,SQL.90).gif GetServerInfo Returns the SQL Server version number of the SQL Server product installed on the target server.
ms211654.pubmethod(en-US,SQL.90).gif GetServerVersionEx Returns the edition, product level, and other values that indicate the version of SSIS installed.
ms211654.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms211654.pubmethod(en-US,SQL.90).gif LoadFromDtsServer Loads a package from the specified server.
ms211654.pubmethod(en-US,SQL.90).gif LoadFromSqlServer Loads a package from SQL Server by specifying the server name, user name, and password.
ms211654.pubmethod(en-US,SQL.90).gif LoadFromSqlServer2  
ms211654.pubmethod(en-US,SQL.90).gif LoadPackage Overloaded. Loads a package.
ms211654.pubmethod(en-US,SQL.90).gifms211654.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms211654.pubmethod(en-US,SQL.90).gifms211654.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms211654.pubmethod(en-US,SQL.90).gifms211654.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms211654.pubmethod(en-US,SQL.90).gif RemoveFolderFromDtsServer Removes the specified folder from the specified server.
ms211654.pubmethod(en-US,SQL.90).gif RemoveFolderFromSqlServer Removes the specified folder from the specified instance of SQL Server.
ms211654.pubmethod(en-US,SQL.90).gif RemoveFromDtsServer Removes a package from the specified server.
ms211654.pubmethod(en-US,SQL.90).gif RemoveFromSqlServer Removes a package from the specified instance of SQL Server.
ms211654.pubmethod(en-US,SQL.90).gif RenameFolderOnDtsServer Renames a folder on the specified instance of SQL Server.
ms211654.pubmethod(en-US,SQL.90).gif RenameFolderOnSqlServer Renames a folder on the specified instance of SQL Server.
ms211654.pubmethod(en-US,SQL.90).gif SaveToDtsServer Saves a package to the file system.
ms211654.pubmethod(en-US,SQL.90).gif SaveToSqlServer Saves a package to an instance of SQL Server.
ms211654.pubmethod(en-US,SQL.90).gif SaveToSqlServerAs Saves a package to an instance of SQL Server with a new name.
ms211654.pubmethod(en-US,SQL.90).gif SaveToXml Saves the XML definition of a package to a file.
ms211654.pubmethod(en-US,SQL.90).gif 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 Servermsdb database.
ms211654.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms211654.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms211654.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

Application Class
Microsoft.SqlServer.Dts.Runtime Namespace