Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.
For more information, see ApplicationClass.
Namespace: Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly: Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)
Syntax
'Declaration
<GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")> _
Public Interface Application _
Inherits IDTSApplication100
'Usage
Dim instance As Application
[GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")]
public interface Application : IDTSApplication100
[GuidAttribute(L"E8102616-3E24-4827-85B2-4897E71B598B")]
public interface class Application : IDTSApplication100
[<GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")>]
type Application =
interface
interface IDTSApplication100
end
public interface Application extends IDTSApplication100
The Application type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
CheckSignatureOnLoad | Infrastructure. Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package. (Inherited from IDTSApplication100.) |
|
ComponentStorePath | Infrastructure. Returns the path where pipeline components are stored. This property is read-only. (Inherited from IDTSApplication100.) |
|
ConnectionInfos | Infrastructure. Returns a IDTSConnectionInfos100 collection that contains IDTSConnectionInfo100 objects. This property is read-only. (Inherited from IDTSApplication100.) |
|
DataTypeInfos | Infrastructure. Returns a IDTSDataTypeInfos100 collection that contains IDTSDataTypeInfo100 objects. This property is read-only. (Inherited from IDTSApplication100.) |
|
DBProviderInfos | Infrastructure. Returns a IDTSDBProviderInfos100 collection that contains IDTSDBProviderInfo100 objects in the application. This property is read-only. (Inherited from IDTSApplication100.) |
|
ForEachEnumeratorInfos | Infrastructure. Returns a IDTSForEachEnumeratorInfos100 collection that contains IDTSForEachEnumeratorInfo100 objects. This property is read-only. (Inherited from IDTSApplication100.) |
|
LogProviderInfos | Infrastructure. Returns a IDTSLogProviderInfos100 collection that contains IDTSLogProviderInfo100 objects. This property is read-only. (Inherited from IDTSApplication100.) |
|
PackagePassword | Infrastructure. Sets the value of the password for the package. This property is write-only. (Inherited from IDTSApplication100.) |
|
PackageUpgradeOptions | Infrastructure. Gets or sets a value that indicates which upgrade options will be applied to a collection of Integration Services packages during the upgrade process. (Inherited from IDTSApplication100.) |
|
PipelineComponentInfos | Infrastructure. Returns a IDTSPipelineComponentInfos100 collection that contains IDTSPipelineComponentInfo100 objects. (Inherited from IDTSApplication100.) |
|
ProjectPassword | Infrastructure. Sets the value of the password for the project. This property is write-only. (Inherited from IDTSApplication100.) |
|
TaskInfos | Infrastructure. Returns a IDTSTaskInfos100 collection that contains IDTSTaskInfo100 objects. This property is read-only. (Inherited from IDTSApplication100.) |
|
UpdateObjects | Infrastructure. Gets or sets a Boolean that indicates whether extensible objects can be updated at package load time if an updated version is found. (Inherited from IDTSApplication100.) |
|
UpdatePackage | Infrastructure. Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found. (Inherited from IDTSApplication100.) |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
CloseProject | Infrastructure. Closes a specified project. (Inherited from IDTSApplication100.) |
|
CreateFolderOnDtsServer | Infrastructure. Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. (Inherited from IDTSApplication100.) |
|
CreateFolderOnSQLServer | Infrastructure. Creates a folder on the specified instance of SQL Server. (Inherited from IDTSApplication100.) |
|
CreateSsisServerExecution | Infrastructure. Creates SSIS server execution. (Inherited from IDTSApplication100.) |
|
DataTypeInfoFromDataType | Infrastructure. Returns the IDTSDataTypeInfo100 object for the specified data type. (Inherited from IDTSApplication100.) |
|
ExistsOnDtsServer | Infrastructure. Returns a Boolean that indicates whether the specified package already exists on the Integration Services service. (Inherited from IDTSApplication100.) |
|
ExistsOnSQLServer | Infrastructure. Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server. (Inherited from IDTSApplication100.) |
|
FolderExistsOnDtsServer | Infrastructure. Returns a Boolean that indicates whether the specified folder already exists on the file system. (Inherited from IDTSApplication100.) |
|
FolderExistsOnSQLServer | Infrastructure. Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server. (Inherited from IDTSApplication100.) |
|
FolderFromPath | Infrastructure. Returns a Boolean that indicates whether the specified folder already exists on the file system. (Inherited from IDTSApplication100.) |
|
GetDtsServerPackageInfos | Infrastructure. Gets a IDTSPackageInfos100 collection that contains the packages stored in the SSIS Package Store on an instance of SQL Server, within the specified folder. (Inherited from IDTSApplication100.) |
|
GetDtsServerRoles | Infrastructure. Returns an array of Strings that lists the roles available for a folder. (Inherited from IDTSApplication100.) |
|
GetPackageInfos | Infrastructure. Gets a IDTSPackageInfos100 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. (Inherited from IDTSApplication100.) |
|
GetPackageInfos2 | Infrastructure. Gets a IDTSPackageInfos100 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. (Inherited from IDTSApplication100.) |
|
GetPackageRoles | Infrastructure. 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. (Inherited from IDTSApplication100.) |
|
GetRunningPackages | Infrastructure. Returns a IDTSRunningPackages100 collection that contains IDTSRunningPackage100 objects. This property is read-only. (Inherited from IDTSApplication100.) |
|
GetServerInfo | Infrastructure. Returns the SQL Server version number of the SQL Server product installed on the target server. (Inherited from IDTSApplication100.) |
|
GetServerVersionEx | Infrastructure. Returns the edition, product level, and other values that indicate the version of SSIS installed. (Inherited from IDTSApplication100.) |
|
LoadFromDtsServer | Infrastructure. Loads a package from the specified server, and specifies the threading model. (Inherited from IDTSApplication100.) |
|
LoadFromSQLServer | Infrastructure. Loads a package from SQL Server by specifying the server name, user name, and password. (Inherited from IDTSApplication100.) |
|
LoadFromSQLServer2 | Infrastructure. Loads a package from SQL Server by specifying the server name, user name, and password. (Inherited from IDTSApplication100.) |
|
LoadPackage | Infrastructure. Loads a IDTSPackage100 from the file system. (Inherited from IDTSApplication100.) |
|
OpenProject | Infrastructure. Opens a specified project. (Inherited from IDTSApplication100.) |
|
RemoveFolderFromDtsServer | Infrastructure. Removes the specified folder from the specified server. (Inherited from IDTSApplication100.) |
|
RemoveFolderFromSQLServer | Infrastructure. Removes the specified folder from the specified instance of SQL Server. (Inherited from IDTSApplication100.) |
|
RemoveFromDtsServer | Infrastructure. Removes a package from the specified server. (Inherited from IDTSApplication100.) |
|
RemoveFromSQLServer | Infrastructure. Removes a package from the specified instance of SQL Server. (Inherited from IDTSApplication100.) |
|
RenameFolderOnDtsServer | Infrastructure. Renames a folder on the specified server. (Inherited from IDTSApplication100.) |
|
RenameFolderOnSQLServer | Infrastructure. Renames a folder on the specified instance of SQL Server. (Inherited from IDTSApplication100.) |
|
SavePackage | Infrastructure. Saves a package to the file system. (Inherited from IDTSApplication100.) |
|
SaveToDtsServer | Infrastructure. Saves a package to the specified server. (Inherited from IDTSApplication100.) |
|
SaveToSQLServer | Infrastructure. Saves a package to an instance of SQL Server. (Inherited from IDTSApplication100.) |
|
SaveToSQLServerAs | Infrastructure. Saves a package to an instance of SQL Server with a new name. (Inherited from IDTSApplication100.) |
|
SaveToXML | Infrastructure. Saves the XML definition of a package to a file. (Inherited from IDTSApplication100.) |
|
SetPackageRoles | Infrastructure. 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. (Inherited from IDTSApplication100.) |
Top