DimStudentObjectiveLoad
 OLE_DST Load SCD1 Temp Table for Student Objective (Component)
  Properties
Property Value
Name OLE_DST Load SCD1 Temp Table for Student Objective
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 Student Objective" (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_DimStudentObjective__Type1Update]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
ActualGraduationTerm
6808
6702
ActualGraduationTermTitle
6809
6703
AdmissionStatus
6802
6696
AwardType
6124
5894
AwardTypeCode
6123
5893
EffectiveTerm
6799
6693
EffectiveTermTitle
6800
6694
ExpectedGraduationTerm
6806
6700
ExpectedGraduationTermTitle
6807
6701
GraduationAge
6923
6907
GraduationAgeRange
6924
6908
GraduationHonorsCode
6810
6704
GraduationStatusCode
6805
6699
PrimaryObjective
6803
6697
Program
6113
5883
ProgramCode
6112
5882
ProgramStatusCode
6804
6698
ReportedTerm
6815
6709
ReportedTermTitle
6816
6710
SequenceNumber
6801
6695
StudentId
6109
5879
StudentObjectiveAK
6798
6692
StudentObjectiveSK
6797
6691
TransferInstitution
6814
6708
TransferInstitutionId
6813
6707
TransferMajor
6812
6706
TransferMajorCode
6811
6705
  Output Columns
Name ID LineageID
ErrorCode
4895
4895
ErrorColumn
4896
4896
Powered by BI Documenter