DimProgramRetentionCohortLoad
 OLE_DST Load New Temp Table for Program Retention Cohort (Component)
  Properties
Property Value
Name OLE_DST Load New Temp Table for Program Retention Cohort
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 4581
Component Class ID {5A0B62E8-D91D-49F5-94A5-7BE58DE508F0}
Contact Info OLE DB Destination;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4
Identification String component "OLE_DST Load New Temp Table for Program Retention Cohort" (4581)
Is Default Locale True
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 4
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
AccessMode
3
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
FastLoadKeepIdentity
False
FastLoadKeepNulls
False
FastLoadMaxInsertCommitSize
2147483647
FastLoadOptions
TABLOCK,CHECK_CONSTRAINTS
OpenRowset
[dbo].[Staged_dbo_DimProgramRetentionCohort__New]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
AgeAtProgramRetentionCohort
7706
7574
AgeRangeAtProgramRetentionCohort
7707
7575
AwardType
6058
5828
AwardTypeCode
6057
5827
CIP
7705
7573
CIPCode
7704
7572
CohortTerm
7080
7011
CohortTermTitle
7081
7012
Program
6047
5817
ProgramAdmitStatus
7082
7013
ProgramCode
6046
5816
ProgramRetentionCohortAK
7703
7571
RowEndDate
4751
4264
RowIsCurrent
4749
4262
RowStartDate
4750
4263
StudentId
6043
5813
SwitchedAwardType
7713
7581
SwitchedAwardTypeCode
7712
7580
SwitchedCIP
7715
7583
SwitchedCIPCode
7714
7582
SwitchedProgram
7709
7577
SwitchedProgramCode
7708
7576
SwitchedTerm
7710
7578
SwitchedTermTitle
7711
7579
  Output Columns
Name ID LineageID
ErrorCode
4596
4596
ErrorColumn
4597
4597
Powered by BI Documenter