FactPriorEnrollmentSnapshotLoad
 FELC Loop Thru Prior Terms (ForEach Loop)
  Properties
Property Value
Name FELC Loop Thru Prior Terms
Description Foreach Loop Container
Precedence Executables none
Contrained Executables none
ID fb4b3594-9a5d-4c28-8955-309853d4b2cf
Delay Validation False
Disable False
Disable Event Handlers False
Fail Package On Failure False
Fail Parent On Failure False
Force Execution Result None
Force Execution Value False
Isolation Level Serializable
Locale ID 1033
Logging Mode UseParentSetting
Suspend Required False
Transaction Option Supported
ForEachEnumerator.CollectionEnumerator True
ForEachEnumerator.CreationName Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumerator, Microsoft.SqlServer.ForEachADOEnumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ForEachEnumerator.DataObjectVariable User::EnrollmentTerms
ForEachEnumerator.Description
ForEachEnumerator.ID {32d65cf3-c803-4c4f-9fca-fcb767ea97ab}
ForEachEnumerator.Name {FCAB6FA7-FAB1-49D6-8867-5140A358CC26}
ForEachEnumerator.Type 2
ForEachEnumerator.VariableMappings 0 , User::PriorYearTermResults
1 , User::ActiveTermResults
2 , User::PriorRelativeDay
3 , User::PriorYearDateResults
ForEachEnumerator.Version 0
  Executables
Name Type Description
Data Flow Task
Data Flow Task
Data Flow Task
Data Flow Task
Task
Execute SQL Task
  Variables
Name Value Description
Powered by BI Documenter