DimProgramRetentionCohortLoad
 OLE_DST Load SCD1 Temp Table for Program Retention Cohort (Component)
  Properties
Property Value
Name OLE_DST Load SCD1 Temp Table for Program Retention Cohort
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 4880
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 SCD1 Temp Table for Program Retention Cohort" (4880)
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__Type1Update]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
AgeAtProgramRetentionCohort
7680
7604
AgeRangeAtProgramRetentionCohort
7681
7605
AwardType
6124
5894
AwardTypeCode
6123
5893
CIP
7679
7603
CIPCode
7678
7602
CohortTerm
7067
7027
CohortTermTitle
7068
7028
Program
6113
5883
ProgramAdmitStatus
7069
7029
ProgramCode
6112
5882
ProgramRetentionCohortAK
7677
7601
ProgramRetentionCohortSK
7676
7600
StudentId
6109
5879
SwitchedAwardType
7687
7611
SwitchedAwardTypeCode
7686
7610
SwitchedCIP
7689
7613
SwitchedCIPCode
7688
7612
SwitchedProgram
7683
7607
SwitchedProgramCode
7682
7606
SwitchedTerm
7684
7608
SwitchedTermTitle
7685
7609
  Output Columns
Name ID LineageID
ErrorCode
4895
4895
ErrorColumn
4896
4896
Powered by BI Documenter