Enumerazione DTSObjectHostType

Describes the type of container that is hosting the other task or container.

Spazio dei nomi  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Sintassi

'Dichiarazione
Public Enumeration DTSObjectHostType
'Utilizzo
Dim instance As DTSObjectHostType

public enum DTSObjectHostType

public enum class DTSObjectHostType

type DTSObjectHostType

public enum DTSObjectHostType

Membri

	Nome membro	Descrizione
	Task	The host is a task.
	ConnectionManager	The host is a connection manager.
	LogProvider	The host is a log provider.
	ForEachEnumerator	The host is a Foreach enumerator.

Esempi

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

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Dts.Runtime