Export (0) Print
Expand All

Application Methods

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

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

Community Additions

ADD
Show:
© 2014 Microsoft