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