DtsErrors.Contains(Object) Metode
Definisi
Penting
Beberapa informasi terkait produk prarilis yang dapat diubah secara signifikan sebelum dirilis. Microsoft tidak memberikan jaminan, tersirat maupun tersurat, sehubungan dengan informasi yang diberikan di sini.
Mengembalikan Boolean yang menunjukkan apakah item dalam koleksi dapat diakses dengan menggunakan pengindeksan tanpa melemparkan pengecualian.
public:
bool Contains(System::Object ^ index);
public bool Contains (object index);
member this.Contains : obj -> bool
Public Function Contains (index As Object) As Boolean
Parameter
Mengembalikan
Boolean yang menunjukkan apakah koleksi dapat diakses oleh kode deskripsi, nomor kesalahan, atau indeks. Nilai true menunjukkan bahwa koleksi dapat diakses dengan menggunakan sintaks DtsErrors[index]. Nilai false menunjukkan bahwa pengindeksan tidak dapat digunakan untuk mengambil item dari DtsErrors koleksi.
Contoh
Contoh kode berikut membuat tugas Kirim Email dan menambahkannya ke paket. Tidak semua properti yang diperlukan dari tugas Kirim Email diatur, jadi ketika paket berjalan, ada kesalahan dan peringatan dalam DtsErrors koleksi dan DtsWarnings . Metode Contains ini digunakan untuk melihat apakah koleksi dapat diakses menggunakan DtsErrors[index]
sintaks, dan jika demikian, mendapatkan beberapa properti menggunakan sintaks tersebut.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.SendMailTask;
namespace Microsoft.SqlServer.SSIS.Samples
{
class Program
{
static void Main(string[] args)
{
Package package = new Package();
TaskHost taskH2 = (TaskHost)package.Executables.Add("STOCK:SendMailTask");
taskH2.FailPackageOnFailure = false;
taskH2.FailParentOnFailure = false;
Console.WriteLine("SendMailTask: {0}", taskH2.ID);
package.MaximumErrorCount = 100;
package.FailPackageOnFailure = false;
package.FailParentOnFailure = false;
package.DelayValidation = true;
package.Execute();
// Get the collections.
DtsWarnings dtsWarns = package.Warnings;
DtsErrors dtsErrs = package.Errors;
// Use Contains to see if collection can be accessed
// using item syntax of [x].
Boolean warnItem = dtsWarns.Contains(0);
Boolean errItem = dtsErrs.Contains(0);
// If item sytax can be used, use it to obtain information.
if (warnItem)
{
//Using the Item method syntax of [x], obtain the first entry and a description.
DtsWarning firstWItem = dtsWarns[0];
String nameOfFirstItem = dtsWarns[0].SubComponent;
//Print the subcomponent for the warning located at position [0] two ways.
Console.WriteLine("The first warning subcomponent is: {0}", firstWItem.SubComponent);
Console.WriteLine("The first warning subcomponent is: {0}", nameOfFirstItem);
}
// If item sytax can be used, use it to obtain information.
if (errItem)
{
//Using the Item method syntax of [x], obtain the first entry and a description.
DtsError firstEItem = dtsErrs[0];
String nameOfFirstItem = dtsErrs[0].Description;
//Print the description of the warning located at position [0] two ways.
Console.WriteLine("The first error description is: {0}", firstEItem.Description);
Console.WriteLine("The first error description is: {0}", nameOfFirstItem);
}
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.SendMailTask
Namespace Microsoft.SqlServer.SSIS.Samples
Class Program
static void Main(string() args)
{
Dim package As Package = New Package()
Dim taskH2 As TaskHost = CType(package.Executables.Add("STOCK:SendMailTask"), TaskHost)
taskH2.FailPackageOnFailure = False
taskH2.FailParentOnFailure = False
Console.WriteLine("SendMailTask: {0}", taskH2.ID)
package.MaximumErrorCount = 100
package.FailPackageOnFailure = False
package.FailParentOnFailure = False
package.DelayValidation = True
package.Execute()
' Get the collections.
Dim dtsWarns As DtsWarnings = package.Warnings
Dim dtsErrs As DtsErrors = package.Errors
' Use Contains to see if collection can be accessed
' using item syntax of [x].
Dim warnItem As Boolean = dtsWarns.Contains(0)
Dim errItem As Boolean = dtsErrs.Contains(0)
' If item sytax can be used, use it to obtain information.
if (warnItem)
{
'Using the Item method syntax of [x], obtain the first entry and a description.
Dim firstWItem As DtsWarning = dtsWarns(0)
Dim nameOfFirstItem As String = dtsWarns(0).SubComponent
'Print the subcomponent for the warning located at position [0] two ways.
Console.WriteLine("The first warning subcomponent is: {0}", firstWItem.SubComponent)
Console.WriteLine("The first warning subcomponent is: {0}", nameOfFirstItem)
}
' If item sytax can be used, use it to obtain information.
if (errItem)
{
'Using the Item method syntax of [x], obtain the first entry and a description.
Dim firstEItem As DtsError = dtsErrs(0)
Dim nameOfFirstItem As String = dtsErrs(0).Description
'Print the description of the warning located at position [0] two ways.
Console.WriteLine("The first error description is: {0}", firstEItem.Description)
Console.WriteLine("The first error description is: {0}", nameOfFirstItem)
}
}
End Class
End Namespace
Contoh Output:
SendMailTask: {12ADD307-23DA-42C9-A4B2-E360DEFD7563}
The first warning subcomponent is: Send Mail Task
The first warning subcomponent is: Send Mail Task
The first error description is: SMTP Server not specified
The first error description is: SMTP Server not specified