ForEachVariableMapping.Name プロパティ
ユーザー インターフェイスに使用されるマッピングの名前を表す String を取得します。値の設定も可能です。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public Property Name As String
Get
Set
'使用
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)
プロパティ値
型: System.String
オブジェクトの名前を表す String です。
実装
説明
この名前は、CreationName と異なる場合があります。 IDTSName から継承されるいくつかのランタイム オブジェクトでは、この Name プロパティが、グラフィカル ユーザー インターフェイスで表示される値になります。
使用例
次のコード例では、ForEachVariableMapping の作成、読み取り/書き込みプロパティの設定、読み取り専用プロパティの表示、および VariableName プロパティと ValueIndex プロパティを使用したマッピングの設定を行います。
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
サンプル出力:
ID: {DDCF34B7-853F-4013-B924-93D1A00DEC3F}
CreationName: