ForEachVariableMapping.ID Eigenschaft

Definition

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Ruft eine Zeichenfolge ab, die die eindeutige ID enthält, die der Variablen zugewiesen ist. Dies ist normalerweise eine GUID. Diese Eigenschaft ist schreibgeschützt.

public:
 property System::String ^ ID { System::String ^ get(); };

[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "IDDesc")]
public string ID { get; }

[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "IDDesc")>]
member this.ID : string

Public ReadOnly Property ID As String

Eigenschaftswert

String

Eine Zeichenfolge, die eine eindeutige ID enthält, in der Regel eine GUID.

Implementiert

ID

Attribute

LocalizablePropertyDescriptionAttribute

Beispiele

Im folgenden Codebeispiel wird eine ForEachVariableMapping, legt die Lese-/Schreibeigenschaften fest, zeigt die schreibgeschützten Eigenschaften an und richtet eine Zuordnung mithilfe der und ValueIndex der VariableName Eigenschaften ein.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  
using Microsoft.SqlServer.Dts.Runtime.Enumerators;  
using Microsoft.SqlServer.Dts.Runtime.Enumerators.Item;  

namespace Microsoft.SqlServer.SSIS.Samples  
{  
    class Program  
    {  
        public static void Main()  
        {  
            // Create the new application and package.  
            Application app = new Application();  
            Package package = new Package();  

            // Create ForEachLoop task  
            Executables executables = package.Executables;  
            ForEachLoop forEachLoop = executables.Add("STOCK:FOREACHLOOP") as ForEachLoop;  

            // Create a VariableMappings and VariableMapping objects.  
            ForEachVariableMappings forEachVariableMappings = forEachLoop.VariableMappings;  
            ForEachVariableMapping forEachVariableMapping = forEachVariableMappings.Add();  
            // Set the properties.  
            forEachVariableMapping.Description = "My ForEach Variable Mapping";  
            forEachVariableMapping.Name = "My Name is ForEachVariableMapping";  

            // View the read-only properties. CreationName can be blank.  
            Console.WriteLine("ID:           {0}", forEachVariableMapping.ID);  
            Console.WriteLine("CreationName: {0}", forEachVariableMapping.CreationName);  

            // Create a mapping between the variable and its value.  
            forEachVariableMapping.VariableName = @"Id";  
            forEachVariableMapping.ValueIndex = 0;  

            // Add other tasks to ForEachLoop container.  
            //...  

            // Run the package when the rest of the code is finished.   
            DTSExecResult status = package.Execute();  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  
Imports Microsoft.SqlServer.Dts.Runtime.Enumerators  
Imports Microsoft.SqlServer.Dts.Runtime.Enumerators.Item  

Namespace Microsoft.SqlServer.SSIS.Samples  

   Class Program  

      Public Shared Sub Main()  
         ' Create the new application and package.  
         Dim app As New Application()  
         Dim package As New Package()  

         ' Create ForEachLoop task  
         Dim executables As Executables = package.Executables  
         Dim forEachLoop As ForEachLoop = CType(executables.Add("STOCK:FOREACHLOOP"), ForEachLoop)  

         ' Create a VariableMappings and VariableMapping objects.  
         Dim forEachVariableMappings As ForEachVariableMappings = forEachLoop.VariableMappings  
         Dim forEachVariableMapping As ForEachVariableMapping = forEachVariableMappings.Add()  
         ' Set the properties.  
         forEachVariableMapping.Description = "My ForEach Variable Mapping"  
         forEachVariableMapping.Name = "My Name is ForEachVariableMapping"  

         ' View the read-only properties. CreationName can be blank.  
         Console.WriteLine("ID:           {0}", forEachVariableMapping.ID)  
         Console.WriteLine("CreationName: {0}", forEachVariableMapping.CreationName)  

         ' Create a mapping between the variable and its value.  
         forEachVariableMapping.VariableName = "Id"  
         forEachVariableMapping.ValueIndex = 0  

         Console.WriteLine()  

         ' Add other tasks to ForEachLoop container.  
         '...  
         ' Run the package when the rest of the code is finished.   
         Dim status As DTSExecResult = package.Execute()  
      End Sub 'Main  
   End Class 'Program  
End Namespace 'Microsoft.SqlServer.SSIS.Samples  

Beispielausgabe:

ID: {DDCF34B7-853F-4013-B924-93D1A00DEC3F}

CreationName: