Export (0) Print
Expand All

Application Methods

The Application type exposes the following members.

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

Community Additions

ADD
Show:
© 2014 Microsoft