Propriedade do RDL ForEachVariableMapping.Name

Artigo
04/26/2013

Gets or sets a String that contains the name for the mapping that is used in the user interface.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (em Microsoft.SqlServer.ManagedDTS.dll)

Sintaxe

'Declaração
Public Property Name As String 
    Get 
    Set
'Uso
Dim instance As ForEachVariableMapping 
Dim value As String 

value = instance.Name

instance.Name = value

public string Name { get; set; }

public:
virtual property String^ Name {
    String^ get () sealed;
    void set (String^ value) sealed;
}

abstract Name : string with get, set 
override Name : string with get, set

final function get Name () : String 
final function set Name (value : String)

Valor da propriedade

Tipo: System.String
A String that contains the object name.

Implementa

IDTSName.Name

Comentários

This name may not be the same as the CreationName. In several runtime objects that inherit from IDTSName, this Name property is the value shown in the graphical user interface.

Exemplos

The following code example creates a ForEachVariableMapping, sets the read-write properties, views the read-only properties, and sets up a mapping using the VariableName and ValueIndex properties.

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

Sample Output:

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

CreationName:

Consulte também

Referência

ForEachVariableMapping Classe

Namespace Microsoft.SqlServer.Dts.Runtime

Compartilhar via