共用方式為

PackageInfo.ExecuteInScaleOut Method

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.IntegrationServices
Assembly:
Microsoft.SqlServer.Management.IntegrationServices.dll

Executes the package in cluster

public:
 long ExecuteInScaleOut(bool use32RuntimeOn64, Microsoft::SqlServer::Management::IntegrationServices::EnvironmentReference ^ reference, System::Collections::ObjectModel::Collection<Microsoft::SqlServer::Management::IntegrationServices::PackageInfo::ExecutionValueParameterSet ^> ^ setValueParameters, System::Collections::ObjectModel::Collection<Microsoft::SqlServer::Management::IntegrationServices::PackageInfo::PropertyOverrideParameterSet ^> ^ propetyOverrideParameters, bool useAnyMachine, System::Collections::ObjectModel::Collection<Guid> ^ workerAgentIds, int retryCount);
public long ExecuteInScaleOut (bool use32RuntimeOn64, Microsoft.SqlServer.Management.IntegrationServices.EnvironmentReference reference, System.Collections.ObjectModel.Collection<Microsoft.SqlServer.Management.IntegrationServices.PackageInfo.ExecutionValueParameterSet> setValueParameters, System.Collections.ObjectModel.Collection<Microsoft.SqlServer.Management.IntegrationServices.PackageInfo.PropertyOverrideParameterSet> propetyOverrideParameters, bool useAnyMachine, System.Collections.ObjectModel.Collection<Guid> workerAgentIds, int retryCount);
member this.ExecuteInScaleOut : bool * Microsoft.SqlServer.Management.IntegrationServices.EnvironmentReference * System.Collections.ObjectModel.Collection<Microsoft.SqlServer.Management.IntegrationServices.PackageInfo.ExecutionValueParameterSet> * System.Collections.ObjectModel.Collection<Microsoft.SqlServer.Management.IntegrationServices.PackageInfo.PropertyOverrideParameterSet> * bool * System.Collections.ObjectModel.Collection<Guid> * int -> int64
Public Function ExecuteInScaleOut (use32RuntimeOn64 As Boolean, reference As EnvironmentReference, setValueParameters As Collection(Of PackageInfo.ExecutionValueParameterSet), propetyOverrideParameters As Collection(Of PackageInfo.PropertyOverrideParameterSet), useAnyMachine As Boolean, workerAgentIds As Collection(Of Guid), retryCount As Integer) As Long

Parameters

use32RuntimeOn64
Boolean

indicates whether to use 32 bit runtime for execution on a 64-bit server

reference
EnvironmentReference

A specified reference to execute the package. If it's null, use parameter default values.

setValueParameters
Collection<PackageInfo.ExecutionValueParameterSet>

A collection of parameter sets to set values for parameters.

propetyOverrideParameters
Collection<PackageInfo.PropertyOverrideParameterSet>

A collection of parameter sets for property overrides.

useAnyMachine
Boolean

Use any worker

workerAgentIds
Collection<Guid>

Use specific workers

retryCount
Int32

return count

Returns

Int64

The execution ID

Applies to