Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Technical Reference
Application Class
 Application Members
Other versions are also available for the following:
Application Members

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.

  Name Description
Application Initializes a new instance of the Application class.
Top
  Name Description
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.
Top
(see also Protected Methods )
  Name Description
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. This method is not CLS-compliant.
Equals  Overloaded. (inherited from 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.
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. (inherited from 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 Servermsdb 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  (inherited from 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 Overloaded. Loads a package.
op_Equality  (inherited from DtsObject )
op_Inequality  (inherited from DtsObject )
ReferenceEquals  (inherited from 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 Servermsdb database.
ToString  (inherited from Object )
Upgrade Upgrades one or more Integration Services packages from a specified source location to a specified destination location.
Top
  Name Description
Finalize  (inherited from Object )
MemberwiseClone  (inherited from Object )
Top
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker