Énumération DTSObjectHostType

Article
04/27/2013

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

Espace de noms : Microsoft.SqlServer.Dts.Runtime
Assembly : Microsoft.SqlServer.ManagedDTS (en Microsoft.SqlServer.ManagedDTS.dll)

Syntaxe

'Déclaration
Public Enumeration DTSObjectHostType
'Utilisation
Dim instance As DTSObjectHostType

public enum DTSObjectHostType

public enum class DTSObjectHostType

type DTSObjectHostType

public enum DTSObjectHostType

Membres

	Nom de membre	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.

Exemples

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

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Dts.Runtime

Partager via