ForEachLoop 成員
Provides a container that defines an iterative workflow in a package using the foreach iteration statement.
ForEachLoop 型別公開下列成員。
方法
名稱 | 描述 | |
---|---|---|
![]() |
AcceptBreakpointManager | This method is called by the run-time engine when a task or container is created, and passes it a BreakpointManager manager to allow the task to create, remove, and check the status of breakpoints. This method is called by the runtime and is not used in code. (繼承自 DtsContainer。) |
![]() |
Dispose | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (繼承自 DtsContainer。) |
![]() |
Equals | Determines whether two object instances are equal. (繼承自 DtsObject。) |
![]() |
Execute | Runs the application, container, or package as part of a package workflow. (繼承自 DtsContainer。) |
![]() |
Finalize | (繼承自 Object。) |
![]() |
GetExpression | Returns a String that contains the expression for the specified property. Null means no expression is assigned. |
![]() |
GetHashCode | Returns the hash code for this instance. (繼承自 DtsObject。) |
![]() |
GetPackagePath | Returns a String that contains the relative path to the package location. |
![]() |
GetType | (繼承自 Object。) |
![]() |
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application..::..LoadPackage method. (繼承自 DtsContainer。) |
![]() |
MemberwiseClone | (繼承自 Object。) |
![]() |
ResumeExecution | Resumes execution of the task after pausing. The task or container is resumed by the runtime engine. (繼承自 DtsContainer。) |
![]() |
SaveToXML | This method is not callable by your application code. To save a package as .xml, use the Application..::..SaveToXml method. (繼承自 DtsContainer。) |
![]() |
SetExpression | Assigns the specified expression to the property. Specify nullNothingnullptrunitnull 參考 (在 Visual Basic 中為 Nothing) to remove an existing expression from the property. |
![]() |
SetWrappedExecutable | 基礎結構。 (繼承自 EventsProvider。) |
![]() |
SuspendExecution | Called when the executable needs to suspend. This method is called by the runtime engine. (繼承自 DtsContainer。) |
![]() |
ToString | (繼承自 Object。) |
![]() |
Validate | Allows the container to determine if it contains invalid settings that will prevent it from executing successfully. (繼承自 DtsContainer。) |
頂端
屬性
名稱 | 描述 | |
---|---|---|
![]() |
CreationName | Returns the string that is used to create an instance of the DtsContainer object. This property is read-only. (繼承自 DtsContainer。) |
![]() |
DebugMode | Gets or sets a Boolean that indicates whether the DtsContainer object is in debug mode and whether it should fire the OnBreakpointHit event while running. (繼承自 DtsContainer。) |
![]() |
DelayValidation | Gets or sets a Boolean that indicates whether validation of the task is delayed until run time. The default value is false. (繼承自 DtsContainer。) |
![]() |
Description | Gets or sets the description of the DtsContainer object. (繼承自 DtsContainer。) |
![]() |
Disable | A Boolean that indicates if the DtsContainer object is disabled. (繼承自 DtsContainer。) |
![]() |
DisableEventHandlers | Gets or sets a Boolean that indicates whether the event handlers on task are disabled. (繼承自 EventsProvider。) |
![]() |
EventHandlers | Returns a collection of event handler objects. This field is read-only. (繼承自 EventsProvider。) |
![]() |
EventInfos | Returns a collection of EventInfo objects. This field is read-only. (繼承自 EventsProvider。) |
![]() |
Executables | Returns a collection of Executable objects processed by the Data Transformation Run-time engine during execution of the ForEachLoop. This field is read-only. |
![]() |
ExecutionDuration | Returns a value that indicates the amount of time that the container spent in execution, in milliseconds. This property is read-only. (繼承自 DtsContainer。) |
![]() |
ExecutionResult | Returns a value that indicates the success or failure of the execution of the DtsContainer object. (繼承自 DtsContainer。) |
![]() |
ExecutionStatus | Returns a value that indicates the current status of the execution of the DtsContainer object at the time of the call. (繼承自 DtsContainer。) |
![]() |
FailPackageOnFailure | Gets or sets a Boolean that indicates whether the package fails when a child container fails. This property is used on containers, not the package itself. (繼承自 DtsContainer。) |
![]() |
FailParentOnFailure | Gets or sets a Boolean that defines whether the parent container fails when a child container fails. (繼承自 DtsContainer。) |
![]() |
ForcedExecutionValue | If the ForceExecutionValue property is set to True, gets or sets a value that specifies the optional execution value that the package returns. (繼承自 DtsContainer。) |
![]() |
ForceExecutionResult | Gets or sets a DTSForcedExecResult enumeration value that specifies the forced execution result of the container. (繼承自 DtsContainer。) |
![]() |
ForceExecutionValue | Gets or sets a Boolean that indicates whether the execution value of the container should be forced to contain a particular value. (繼承自 DtsContainer。) |
![]() |
ForEachEnumerator | Gets or sets a host for the ForEachEnumerator. |
![]() |
ID | Returns the ID, which is a GUID, of the DtsContainer. The value is read-only. (繼承自 DtsContainer。) |
![]() |
IsDefaultLocaleID | A Boolean that indicates whether the container uses the default locale. This property is read-only. (繼承自 DtsContainer。) |
![]() |
IsolationLevel | Gets or sets the isolation level of the transaction in the DtsContainer object. (繼承自 DtsContainer。) |
![]() |
LocaleID | Gets or sets an Integer that indicates the Microsoft Win32® localeID to use when the DtsContainer object is executed. (繼承自 DtsContainer。) |
![]() |
LogEntryInfos | Returns a LogEntryInfos object. This property is read-only. (繼承自 DtsContainer。) |
![]() |
LoggingMode | Gets or sets a valid value from the DTSLoggingMode enumeration that indicates the logging mode of the container. (繼承自 DtsContainer。) |
![]() |
LoggingOptions | Returns an object that contains properties that indicates the filtering and logging resource for containers. This property is read-only. (繼承自 DtsContainer。) |
![]() |
MaximumErrorCount | Gets or sets an Integer value that indicates the maximum number of errors that can occur before the DtsContainer object stops running. (繼承自 DtsContainer。) |
![]() |
Name | Gets or sets the name of the DtsContainer. (繼承自 DtsContainer。) |
![]() |
Parent | Returns the parent container. The value is read-only. (繼承自 DtsContainer。) |
![]() |
PrecedenceConstraints | Returns a PrecedenceConstraints collection that contains all of the precedence constraints associated with the ForEachLoop. |
![]() |
Properties | Returns a collection of DtsProperty objects associated with the ForEachLoop. |
![]() |
Site | 基礎結構。 (繼承自 DtsContainer。) |
![]() |
StartTime | Returns the time that the container began execution. This property is read-only. (繼承自 DtsContainer。) |
![]() |
StopTime | Returns the time that the container ended execution. This property is read-only. (繼承自 DtsContainer。) |
![]() |
SuspendRequired | Gets or sets a Boolean that indicates if tasks should suspend when they encounter a breakpoint. This value is set by the runtime engine for tasks and containers when a breakpoint is encountered. (繼承自 DtsContainer。) |
![]() |
TransactionOption | Gets or sets a DTSTransactionOption enumeration value that indicates whether the container participates in transactions. (繼承自 DtsContainer。) |
![]() |
VariableDispenser | Returns a VariableDispenser object so variables associated with the container can be locked. (繼承自 DtsContainer。) |
![]() |
VariableMappings | Returns a ForEachVariableMappings collection that contains the variable mappings for the ForEachLoop. |
![]() |
Variables | Returns a collection that contains the variables associated with this container. This property is read-only. (繼承自 DtsContainer。) |
頂端
事件
名稱 | 描述 | |
---|---|---|
![]() |
Disposed | Adds an event handler to listen to the Disposed event on the component. (繼承自 DtsContainer。) |
頂端