|
![]() |
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 |
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_DimProgramRetentionCohort__Type1Update] |
OpenRowsetVariable |
|
SqlCommand |
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 |
Name | ID | LineageID |
ErrorCode |
4895 |
4895 |
ErrorColumn |
4896 |
4896 |
Powered by BI Documenter |