|
![]() |
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 |
Name | Connection Manager | Description |
OleDbConnection |
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 |
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 |
Name | ID | LineageID |
ErrorCode |
4895 |
4895 |
ErrorColumn |
4896 |
4896 |
Powered by BI Documenter |