ForEachVariableMapping.ID プロパティ
定義
重要
一部の情報は、リリース前に大きく変更される可能性があるプレリリースされた製品に関するものです。 Microsoft は、ここに記載されている情報について、明示または黙示を問わず、一切保証しません。
変数に割り当てられた一意の ID を含む文字列を取得します。 通常、これが GUID になります。 このプロパティは読み取り専用です。
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 : stringPublic ReadOnly Property ID As Stringプロパティ値
一意の ID (通常は GUID) を含む文字列。
実装
- 属性
例
次のコード例では、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: