DtsProperty.Set Properti

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Mengembalikan Boolean yang menunjukkan apakah properti objek yang direferensikan dapat diubah. Bidang ini hanya-baca.

public:
 property bool Set { bool get(); };

public bool Set { get; }

member this.Set : bool

Public ReadOnly Property Set As Boolean

Nilai Properti

Boolean

Properti ini mengembalikan true ketika properti objek yang dirujuk dapat diubah dan properti yang dirujuk bersifat baca/tulis atau tulis-saja. Jika false, properti yang dirujuk bersifat baca-saja.

Contoh

Contoh kode berikut membuat paket dan menambahkan tugas Sisipkan Massal. Kemudian mendapatkan Properties, dan melihat Get nilai properti dan Set bersama dengan nama properti.

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

namespace Executables_API  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Package pkg = new Package();  
            Executable exec = pkg.Executables.Add("STOCK:BulkInsertTask");  

            // Obtain the collection.  
            Executables pgkExecs = pkg.Executables;  
            foreach (Executable eachExec in pgkExecs)  
            {  
                TaskHost th = exec as TaskHost;  
                Console.WriteLine("Executable creation name is: {0}", th.CreationName);  
            }  

            // Show use of Contains.  

            if (pgkExecs.Contains(0))  
                {  
                // Retrieve executable using [item] syntax.  
                Executable execItem = pgkExecs[0];  
                TaskHost thItem = execItem as TaskHost;  
                DtsProperties myProps = thItem.Properties;  
                foreach (DtsProperty dtsProp in myProps)  
                {  
                    Console.WriteLine("Name {0}, Get? {1} Set? {2}", dtsProp.Name, dtsProp.Get, dtsProp.Set);  
                }  
                Console.WriteLine("Contains returned true");  
            }  
            else  
            {  
                Console.WriteLine("Contains returned false");  
            }  
        }  
    }  
}  

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

Namespace Executables_API  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim pkg As Package =  New Package()   
            Dim exec As Executable =  pkg.Executables.Add("STOCK:BulkInsertTask")   

            ' Obtain the collection.  
            Dim pgkExecs As Executables =  pkg.Executables   
            Dim eachExec As Executable  
            For Each eachExec In pgkExecs  
                Dim th As TaskHost =  exec as TaskHost   
                Console.WriteLine("Executable creation name is: {0}", th.CreationName)  
            Next  

            ' Show use of Contains.  

            If pgkExecs.Contains(0) Then  
                ' Retrieve executable using [item] syntax.  
                Dim execItem As Executable =  pgkExecs(0)   
                Dim thItem As TaskHost =  execItem as TaskHost   
                Dim myProps As DtsProperties =  thItem.Properties   
                Dim dtsProp As DtsProperty  
                For Each dtsProp In myProps  
                    Console.WriteLine("Name {0}, Get? {1} Set? {2}", dtsProp.Name, dtsProp.Get, dtsProp.Set)  
                Next  
                Console.WriteLine("Contains returned true")  
            Else   
                Console.WriteLine("Contains returned false")  
            End If  
        End Sub  
    End Class  
End Namespace  

Contoh Output:

Executable creation name is: Microsoft.SqlServer.Dts.Tasks.BulkInsertTask.BulkInsertTask, Microsoft.SqlServer.BulkInsertTask, Version=10.0.000.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

Name BatchSize, Get? True Set? True

Name CheckConstraints, Get? True Set? True

Name CodePage, Get? True Set? True

Name CreationName, Get? True Set? False

Name DataFileType, Get? True Set? True

Name DebugMode, Get? True Set? True

Name DelayValidation, Get? True Set? True

Name Description, Get? True Set? True

Name FormatFile, Get? True Set? True

Name WaitForMe, Get? True Set? False

Contains returned true