IDTSApplication100 Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Provides properties and methods that are used to discover and access Package objects.
public interface class IDTSApplication100[System.Runtime.InteropServices.Guid("CCE32398-CDF8-47D2-A04F-1EFCA3548481")]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)]
public interface IDTSApplication100[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)]
[System.Runtime.InteropServices.Guid("DD7CDFC6-F283-434E-8C08-4703871D7B07")]
public interface IDTSApplication100[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)]
[System.Runtime.InteropServices.Guid("56B5BFC8-15B2-433B-931B-96295EEC1667")]
public interface IDTSApplication100[<System.Runtime.InteropServices.Guid("CCE32398-CDF8-47D2-A04F-1EFCA3548481")>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)>]
type IDTSApplication100 = interface[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)>]
[<System.Runtime.InteropServices.Guid("DD7CDFC6-F283-434E-8C08-4703871D7B07")>]
type IDTSApplication100 = interface[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)>]
[<System.Runtime.InteropServices.Guid("56B5BFC8-15B2-433B-931B-96295EEC1667")>]
type IDTSApplication100 = interfacePublic Interface IDTSApplication100- Derived
- Attributes
Remarks
For more information, see ApplicationClass.
Properties
| 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. |
Methods
| CloseProject(IDTSProject100) |
Closes a specified project. |
| CreateFolderOnDtsServer(String, String, String) |
Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. |
| CreateFolderOnSQLServer(String, String, String, String, String) |
Creates a folder on the specified instance of SQL Server. |
| CreateSsisServerExecution(String, String, String, Boolean) |
Creates SSIS server execution. |
| DataTypeInfoFromDataType(DataType) |
Returns the IDTSDataTypeInfo100 object for the specified data type. |
| ExistsOnDtsServer(String, String) |
Returns a Boolean that indicates whether the specified package already exists on the Integration Services service. |
| ExistsOnSQLServer(String, String, String, String) |
Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server. |
| FolderExistsOnDtsServer(String, String) |
Returns a Boolean that indicates whether the specified folder already exists on the file system. |
| FolderExistsOnSQLServer(String, String, String, String) |
Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server. |
| FolderFromPath(String, String, String, String) |
Returns a Boolean that indicates whether the specified folder already exists on the file system. |
| GetDtsServerPackageInfos(String, String) |
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(String, String) |
Returns an array of Strings that lists the roles available for a folder. |
| GetPackageInfos(String, String, String, String) |
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(String, Object) |
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(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. |
| GetRunningPackages(String) |
Returns a IDTSRunningPackages100 collection that contains IDTSRunningPackage100 objects. This property is read-only. |
| GetServerInfo(String, String) |
Returns the SQL Server version number of the SQL Server product installed on the target server. |
| GetServerVersionEx(String, UInt32, DTSProductLevel, String, String) |
Returns the edition, product level, and other values that indicate the version of SSIS installed. |
| LoadFromDtsServer(String, String, Boolean, IDTSEvents100) |
Loads a package from the specified server, and specifies the threading model. |
| LoadFromSQLServer(String, String, String, String, Boolean, IDTSEvents100) |
Loads a package from SQL Server by specifying the server name, user name, and password. |
| LoadFromSQLServer2(String, Object, Boolean, IDTSEvents100) |
Loads a package from SQL Server by specifying the server name, user name, and password. |
| LoadPackage(String, Boolean, IDTSEvents100) |
Loads a IDTSPackage100 from the file system. |
| OpenProject(String, IDTSEvents100) |
Opens a specified project. |
| RemoveFolderFromDtsServer(String, String) |
Removes the specified folder from the specified server. |
| RemoveFolderFromSQLServer(String, String, String, String) |
Removes the specified folder from the specified instance of SQL Server. |
| RemoveFromDtsServer(String, String) |
Removes a package from the specified server. |
| RemoveFromSQLServer(String, String, String, String) |
Removes a package from the specified instance of SQL Server. |
| RenameFolderOnDtsServer(String, String, String, String) |
Renames a folder on the specified server. |
| RenameFolderOnSQLServer(String, String, String, String, String, String) |
Renames a folder on the specified instance of SQL Server. |
| SavePackage(String, IDTSPackage100, IDTSEvents100) |
Saves a package to the file system. |
| SaveToDtsServer(IDTSPackage100, IDTSEvents100, String, String) |
Saves a package to the specified server. |
| SaveToSQLServer(IDTSPackage100, IDTSEvents100, String, String, String) |
Saves a package to an instance of SQL Server. |
| SaveToSQLServerAs(IDTSPackage100, IDTSEvents100, String, String, String, String) |
Saves a package to an instance of SQL Server with a new name. |
| SaveToXML(String, IDTSPersist100, IDTSEvents100) |
Saves the XML definition of a package to a file. |
| 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. |