DTSObjectHostType Enumeration
Describes the type of container that is hosting the other task or container.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public Enumeration DTSObjectHostType
'Usage
Dim instance As DTSObjectHostType
public enum DTSObjectHostType
public enum class DTSObjectHostType
type DTSObjectHostType
public enum DTSObjectHostType
Members
| Member name | Description | |
|---|---|---|
| ConnectionManager | The host is a connection manager. | |
| ForEachEnumerator | The host is a Foreach enumerator. | |
| LogProvider | The host is a log provider. | |
| Task | The host is a task. |
Examples
The following code example creates a package and adds a Sequence container to it. A FileSystemTask is then added to the task host, and the HostType property is reviewed, returning a value from the DTSObjectHostType enumeration.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.FileSystemTask;
namespace Microsoft.SqlServer.SSIS.Samples
{
class mySample
{
static void Main(string[] args)
{
Package package = new Package();
Sequence seq = (Sequence)package.Executables.Add("STOCK:SEQUENCE");
// Add a File System task.
Executable eFileTask1 = seq.Executables.Add("STOCK:FileSystemTask");
TaskHost thFileTask1 = eFileTask1 as TaskHost;
// Use the TaskHost variable to find the DtsObjectHostType.
DTSObjectHostType hType = thFileTask1.HostType;
Console.WriteLine("Host Type: {0}", hType);
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.FileSystemTask
Namespace Microsoft.SqlServer.SSIS.Samples
Class mySample
Shared Sub Main(ByVal args() As String)
Dim package As Package = New Package()
Dim seq As Sequence = CType(package.Executables.Add("STOCK:SEQUENCE"), Sequence)
' Add a File System task.
Dim eFileTask1 As Executable = seq.Executables.Add("STOCK:FileSystemTask")
Dim thFileTask1 As TaskHost = eFileTask1 as TaskHost
' Use the TaskHost variable to find the DtsObjectHostType.
Dim hType As DTSObjectHostType = thFileTask1.HostType
Console.WriteLine("Host Type: {0}", hType)
End Sub
End Class
End Namespace
Sample Output:
Host Type: Task