DtsContainer.ExecutionResult Properti
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 nilai yang menunjukkan keberhasilan atau kegagalan eksekusi DtsContainer objek.
public:
property Microsoft::SqlServer::Dts::Runtime::DTSExecResult ExecutionResult { Microsoft::SqlServer::Dts::Runtime::DTSExecResult get(); };
[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryExecution")]
[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "ExecutionResultDesc")]
public Microsoft.SqlServer.Dts.Runtime.DTSExecResult ExecutionResult { get; }
[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryExecution")>]
[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "ExecutionResultDesc")>]
member this.ExecutionResult : Microsoft.SqlServer.Dts.Runtime.DTSExecResult
Public ReadOnly Property ExecutionResult As DTSExecResult
Nilai Properti
Mengembalikan DTSExecResult enumerasi.
- Atribut
Contoh
Contoh kode berikut menjalankan paket yang ada, lalu menunjukkan berapa lama paket berjalan, dalam milidetik. Output juga menampilkan ExecutionResult.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace Microsoft.SqlServer.SSIS.Samples
{
class Program
{
static void Main(string[] args)
{
// The package is the ExecuteProcess package sample
// that is installed with the SSIS samples.
string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\bin\UsingExecuteProcess.dtsx";
Application app = new Application();
Package p1 = app.LoadPackage(pkg, null);
// Show the properties inherited from DtsContainer.
Console.WriteLine("ExecutionDuration: {0}", p1.ExecutionDuration);
// Run the package, then review the execution duration.
p1.Execute();
Console.WriteLine("ExecutionDuration: {0}", p1.ExecutionDuration);
// Also, review the execution result.
Console.WriteLine("ExecutionResult: {0}", p1.ExecutionResult);
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace Microsoft.SqlServer.SSIS.Samples
Class Program
Shared Sub Main(ByVal args() As String)
' The package is the ExecuteProcess package sample
' that is installed with the SSIS samples.
Dim pkg As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\bin\UsingExecuteProcess.dtsx"
Dim app As Application = New Application()
Dim p1 As Package = app.LoadPackage(pkg,Nothing)
' Show the properties inherited from DtsContainer.
Console.WriteLine("ExecutionDuration: {0}", p1.ExecutionDuration)
' Run the package, then review the execution duration.
p1.Execute()
Console.WriteLine("ExecutionDuration: {0}", p1.ExecutionDuration)
' Also, review the execution result.
Console.WriteLine("ExecutionResult: {0}", p1.ExecutionResult)
End Sub
End Class
End Namespace
Contoh Output:
ExecutionDuration: 0
ExecutionDuration: 172
ExecutionResult: Berhasil
Keterangan
Selain menentukan apakah paket atau induk gagal atau berhasil, status hasil eksekusi penting ketika Anda memiliki batasan prioritas yang diatur dalam paket untuk mengontrol alur tugas dalam paket. Item prioritas adalah tugas atau kontainer yang hasil eksekusinya menentukan apakah tugas atau kontainer berikutnya, item yang dibatasi, berjalan.