Интерфейс IDTSApplication100
Этот API-интерфейс поддерживает инфраструктуру SQL Server 2012 и не предназначен для использования непосредственно из кода.
Provides properties and methods that are used to discover and access Package objects.
Пространство имен: Microsoft.SqlServer.Dts.Runtime.Wrapper
Сборка: Microsoft.SqlServer.DTSRuntimeWrap (в Microsoft.SqlServer.DTSRuntimeWrap.dll)
Синтаксис
'Декларация
<GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")> _
Public Interface IDTSApplication100
'Применение
Dim instance As IDTSApplication100
[GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")]
public interface IDTSApplication100
[GuidAttribute(L"E8102616-3E24-4827-85B2-4897E71B598B")]
public interface class IDTSApplication100
[<GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")>]
type IDTSApplication100 = interface end
public interface IDTSApplication100
Тип IDTSApplication100 обеспечивает доступ к следующим элементам.
Свойства
Имя | Описание | |
---|---|---|
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 IDTSConnectionInfos100 collection that contains IDTSConnectionInfo100 objects. This property is read-only. | |
DataTypeInfos | Инфраструктура. Returns a IDTSDataTypeInfos100 collection that contains IDTSDataTypeInfo100 objects. This property is read-only. | |
DBProviderInfos | Инфраструктура. Returns a IDTSDBProviderInfos100 collection that contains IDTSDBProviderInfo100 objects in the application. This property is read-only. | |
ForEachEnumeratorInfos | Инфраструктура. Returns a IDTSForEachEnumeratorInfos100 collection that contains IDTSForEachEnumeratorInfo100 objects. This property is read-only. | |
LogProviderInfos | Инфраструктура. Returns a IDTSLogProviderInfos100 collection that contains IDTSLogProviderInfo100 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 IDTSPipelineComponentInfos100 collection that contains IDTSPipelineComponentInfo100 objects. | |
ProjectPassword | Инфраструктура. Sets the value of the password for the project. This property is write-only. | |
TaskInfos | Инфраструктура. Returns a IDTSTaskInfos100 collection that contains IDTSTaskInfo100 objects. This property is read-only. | |
UpdateObjects | Инфраструктура. 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. |
В начало
Методы
Имя | Описание | |
---|---|---|
CloseProject | Инфраструктура. Closes a specified project. | |
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. | |
CreateSsisServerExecution | Инфраструктура. Creates SSIS server execution. | |
DataTypeInfoFromDataType | Инфраструктура. Returns the IDTSDataTypeInfo100 object for the specified data type. | |
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. | |
FolderFromPath | Инфраструктура. Returns a Boolean that indicates whether the specified folder already exists on the file system. | |
GetDtsServerPackageInfos | Инфраструктура. Gets a IDTSPackageInfos100 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. | |
GetPackageInfos | Инфраструктура. 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. | |
GetPackageInfos2 | Инфраструктура. 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. | |
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 Server msdb database. | |
GetRunningPackages | Инфраструктура. Returns a IDTSRunningPackages100 collection that contains IDTSRunningPackage100 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. | |
LoadFromDtsServer | Инфраструктура. Loads a package from the specified server, and specifies the threading model. | |
LoadFromSQLServer | Инфраструктура. Loads a package from SQL Server by specifying the server name, user name, and password. | |
LoadFromSQLServer2 | Инфраструктура. Loads a package from SQL Server by specifying the server name, user name, and password. | |
LoadPackage | Инфраструктура. Loads a IDTSPackage100 from the file system. | |
OpenProject | Инфраструктура. Opens a specified project. | |
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 server. | |
RenameFolderOnSQLServer | Инфраструктура. Renames a folder on the specified instance of SQL Server. | |
SavePackage | Инфраструктура. Saves a package to the file system. | |
SaveToDtsServer | Инфраструктура. Saves a package to the specified server. | |
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 Server msdb database. |
В начало
Замечания
For more information, see ApplicationClass.