ForLoop Members
Provides a container that defines an iterative workflow in a package, using the for iteration statement.
The following tables list the members exposed by the ForLoop type.
Protected Fields
| 名稱 | Description | |
|---|---|---|
.gif "ms212629.protfield(zh-tw,SQL.90).gif") |
m_executable | (inherited from Executable ) |
頂端
Public Properties
| 名稱 | Description | |
|---|---|---|
.gif "ms212629.pubproperty(zh-tw,SQL.90).gif") |
AssignExpression | Gets or sets an expression to increment or decrement the loop counter. |
|
CreationName | Returns the string that is used to create an instance of the DtsContainer object. This property is read-only. (inherited from 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. (inherited from DtsContainer) |
|
DelayValidation | Gets or sets a Boolean that indicates whether validation of the task is delayed until run time. The default value is false. (inherited from DtsContainer) |
|
Description | Gets or sets the description of the DtsContainer object. (inherited from DtsContainer) |
|
Disable | A Boolean that indicates if the DtsContainer object is disabled. (inherited from DtsContainer) |
|
DisableEventHandlers | Gets or sets a Boolean that indicates whether the event handlers on task are disabled. (inherited from EventsProvider) |
|
EvalExpression | Gets or sets the expression that is evaluated on each pass of the loop. |
|
EventHandlers | Returns a collection of event handler objects. This field is read-only. (inherited from EventsProvider) |
|
EventInfos | Returns a collection of EventInfo objects. This field is read-only. (inherited from EventsProvider) |
|
Executables | Returns a collection of executable objects that are processed during the ForLoop iteration. |
|
ExecutionDuration | Returns a value that indicates the amount of time that the container spent in execution, in milliseconds. This property is read-only. (inherited from DtsContainer) |
|
ExecutionResult | Returns a value that indicates the success or failure of the execution of the DtsContainer object. (inherited from DtsContainer) |
|
ExecutionStatus | Returns a value that indicates the current status of the execution of the DtsContainer object at the time of the call. (inherited from 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. (inherited from DtsContainer) |
|
FailParentOnFailure | Gets or sets a Boolean that defines whether the parent container fails when a child container fails. (inherited from DtsContainer) |
|
ForcedExecutionValue | Gets or sets an object that contains a container-defined value. (inherited from DtsContainer) |
|
ForceExecutionResult | Gets or sets a DTSForcedExecResult enumeration value that specifies the execution result of the container. (inherited from DtsContainer) |
|
ForceExecutionValue | Gets or sets a Boolean that indicates if the execution value of the container should be forced to contain a particular value. (inherited from DtsContainer) |
|
ID | Returns the ID, which is a GUID, of the DtsContainer. The value is read-only. (inherited from DtsContainer) |
|
InitExpression | Gets or sets an optional initialization expression. |
|
IsDefaultLocaleID | A Boolean that indicates whether the container uses the default locale. This property is read-only. (inherited from DtsContainer) |
|
IsolationLevel | Gets or sets the isolation level of the transaction in the DtsContainer object. (inherited from DtsContainer) |
|
LocaleID | Gets or sets an Integer that indicates the Microsoft Win32® localeID to use when the DtsContainer object is executed. (inherited from DtsContainer) |
|
LogEntryInfos | Returns a LogEntryInfos object. This property is read-only. (inherited from DtsContainer) |
|
LoggingMode | Gets or sets a valid value from the DTSLoggingMode enumeration that indicates the logging mode of the container. (inherited from DtsContainer) |
|
LoggingOptions | Returns an object that contains properties that indicates the filtering and logging resource for containers. This property is read-only. (inherited from DtsContainer) |
|
MaximumErrorCount | Gets or sets an Integer value that indicates the maximum number of errors that can occur before the DtsContainer object stops running. (inherited from DtsContainer) |
|
Name | Gets or sets the name of the DtsContainer. (inherited from DtsContainer) |
|
Parent | Returns the parent container. The value is read-only. (inherited from DtsContainer) |
|
PrecedenceConstraints | Returns a PrecedenceConstraints collection. This field is read-only. |
|
Properties | Returns a set of properties for the ForLoop into a DtsProperties collection. |
|
Site | (inherited from DtsContainer ) |
|
StartTime | Returns the time that the container began execution. This property is read-only. (inherited from DtsContainer) |
|
StopTime | Returns the time that the container ended execution. This property is read-only. (inherited from 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. (inherited from DtsContainer) |
|
TransactionOption | Gets or sets a DTSTransactionOption enumeration value that indicates whether the container participates in transactions. (inherited from DtsContainer) |
|
VariableDispenser | Returns a VariableDispenser object so variables associated with the container can be locked. (inherited from DtsContainer) |
|
Variables | Returns a collection that contains the variables associated with this container. This property is read-only. (inherited from DtsContainer) |
頂端
Public Methods
(see also Protected Methods )
| 名稱 | Description | |
|---|---|---|
.gif "ms212629.pubmethod(zh-tw,SQL.90).gif") |
AcceptBreakpointManager | (inherited from DtsContainer ) |
|
Dispose | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (inherited from DtsContainer) |
|
Equals | Overloaded. (inherited from DtsObject ) |
|
Execute | (inherited from DtsContainer ) |
|
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. (inherited from DtsObject) |
|
GetPackagePath | Returns a String that contains the relative path to the package location. |
|
GetType | (inherited from Object ) |
|
LoadFromXML | (inherited from DtsContainer ) |
.gif "ms212629.static(zh-tw,SQL.90).gif") |
op_Equality | (inherited from DtsObject ) |
|
op_Inequality | (inherited from DtsObject ) |
|
ReferenceEquals | (inherited from Object ) |
|
ResumeExecution | Resumes execution of the task after pausing. The task or container is resumed by the runtime engine. (inherited from DtsContainer) |
|
SaveToXML | (inherited from DtsContainer ) |
|
SetExpression | Assigns the specified expression to the property. Specify null to remove an existing expression from the property. |
|
SuspendExecution | Called when the executable needs to suspend. This method is called by the runtime engine. (inherited from DtsContainer) |
|
ToString | (inherited from Object ) |
|
Validate | (inherited from DtsContainer ) |
頂端
Protected Methods
| 名稱 | Description | |
|---|---|---|
.gif "ms212629.protmethod(zh-tw,SQL.90).gif") |
Finalize | (inherited from Object ) |
|
MemberwiseClone | (inherited from Object ) |
|
SetWrappedExecutable | (inherited from EventsProvider ) |
頂端
Public Events
| 名稱 | Description | |
|---|---|---|
.gif "ms212629.pubevent(zh-tw,SQL.90).gif") |
Disposed | Adds an event handler to listen to the Disposed event on the component. (inherited from DtsContainer) |
頂端