Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

Application Methods

 

Applies To: SQL Server 2016 Preview

Namespace:   Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

NameDescription
System_CAPS_pubmethodCreateFolderOnDtsServer(String, String, String)

Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. 

System_CAPS_pubmethodCreateFolderOnSqlServer(String, String, String, String, String)

Creates a folder on the specified instance of SQL Server.

System_CAPS_pubmethodCreateSsisServerExecution(String, String, String, Boolean)

Creates SSIS server execution.

System_CAPS_pubmethodDataTypeInfoFromDataType(DataType)

Returns the DataTypeInfo object for the specified data type.

System_CAPS_pubmethodEquals(Object)

Determines whether two object instances are equal.(Inherited from DtsObject.)

System_CAPS_pubmethodExistsOnDtsServer(String, String)

Returns a Boolean that indicates whether the specified package already exists on the Integration Services service.

System_CAPS_pubmethodExistsOnSqlServer(String, String, String, String)

Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodFolderExistsOnDtsServer(String, String)

Returns a Boolean that indicates whether the specified folder already exists on the file system.

System_CAPS_pubmethodFolderExistsOnSqlServer(String, String, String, String)

Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server.

System_CAPS_pubmethodGetDtsServerPackageInfos(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.

System_CAPS_pubmethodGetDtsServerRoles(String, String)

Returns an array of Strings that lists the roles available for a folder.

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this instance.(Inherited from DtsObject.)

System_CAPS_pubmethodGetPackageInfos(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.

System_CAPS_pubmethodGetPackageInfos2(String, Object)

This API supports the product infrastructure and is not intended to be used directly from your code. 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.

System_CAPS_pubmethodGetPackageRoles(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.

System_CAPS_pubmethodGetRunningPackages(String)

Returns a RunningPackages collection that contains RunningPackage objects. This property is read-only.

System_CAPS_pubmethodGetServerInfo(String, String)

Returns the SQL Server version number of the SQL Server product installed on the target server. 

System_CAPS_pubmethodGetServerVersionEx(String, Int32, DTSProductLevel, String, String)

Returns the edition, product level, and other values that indicate the version of SSIS installed.

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodLoadFromDtsServer(String, String, IDTSEvents)

Loads a package from the specified server.

System_CAPS_pubmethodLoadFromSqlServer(String, String, String, String, IDTSEvents)

Loads a package from SQL Server by specifying the server name, user name, and password.

System_CAPS_pubmethodLoadFromSqlServer2(String, Object, IDTSEvents)

This API supports the product infrastructure and is not intended to be used directly from your code. Loads a package from SQL Server by specifying the server name, user name, and password.

System_CAPS_pubmethodLoadPackage(String, IDTSEvents)

Loads a Package from the file system.

System_CAPS_pubmethodLoadPackage(String, IDTSEvents, Boolean)

Loads a Package from the file system, and specifies the threading model.

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodRemoveFolderFromDtsServer(String, String)

Removes the specified folder from the specified server.

System_CAPS_pubmethodRemoveFolderFromSqlServer(String, String, String, String)

Removes the specified folder from the specified instance of SQL Server.

System_CAPS_pubmethodRemoveFromDtsServer(String, String)

Removes a package from the specified server.

System_CAPS_pubmethodRemoveFromSqlServer(String, String, String, String)

Removes a package from the specified instance of SQL Server.

System_CAPS_pubmethodRenameFolderOnDtsServer(String, String, String, String)

Renames a folder on the specified instance of SQL Server.

System_CAPS_pubmethodRenameFolderOnSqlServer(String, String, String, String, String, String)

Renames a folder on the specified instance of SQL Server.

System_CAPS_pubmethodSaveToDtsServer(Package, IDTSEvents, String, String)

Saves a package to the file system.

System_CAPS_pubmethodSaveToSqlServer(Package, IDTSEvents, String, String, String)

Saves a package to an instance of SQL Server.

System_CAPS_pubmethodSaveToSqlServerAs(Package, IDTSEvents, String, String, String, String)

Saves a package to an instance of SQL Server with a new name.

System_CAPS_pubmethodSaveToXml(String, Package, IDTSEvents)

Saves the XML definition of a package to a file.

System_CAPS_pubmethodSetPackageRoles(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.

System_CAPS_pubmethodToString()

(Inherited from Object.)

System_CAPS_pubmethodUpgrade(IEnumerable<UpgradePackageInfo>, StorageInfo, StorageInfo, BatchUpgradeOptions, IDTSEvents)

Upgrades one or more Integration Services packages from a specified source location to a specified destination location.

Return to top
Show:
© 2015 Microsoft