DimTermLoad
 OLE_SRC Term from Staging (Component)
  Properties
Property Value
Name OLE_SRC Term from Staging
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 30
Component Class ID {BCEFE59B-6819-47F7-A125-63753B33ABB7}
Contact Info OLE DB Source;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7
Identification String component "OLE_SRC Term from Staging" (30)
Is Default Locale False
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 7
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
AccessMode
3
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand
SELECT 1 AS A
SqlCommandVariable
User::SQLTermSource
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
ErrorCode
82
82
ErrorColumn
83
83
SCRPriorYearTerm
75
75
SRCAcademicYear
79
79
SRCAcademicYearCode
78
78
SRCActiveTerm
80
80
SRCDefaultTerm
81
81
SRCRelativeDay
142
142
SRCTermAK
70
70
SRCTermEndDate
72
72
SRCTermSK
69
69
SRCTermStartDate
71
71
SRCTermTitle
73
73
SRCTermType
77
77
SRCTermTypeCode
76
76
SRCTermYear
74
74
StateReportingTermSequence
238
238
StateReportingTermYear
235
235
SCRPriorYearTerm
48
48
SRCAcademicYear
52
52
SRCAcademicYearCode
51
51
SRCActiveTerm
53
53
SRCDefaultTerm
54
54
SRCRelativeDay
141
141
SRCTermAK
43
43
SRCTermEndDate
45
45
SRCTermSK
42
42
SRCTermStartDate
44
44
SRCTermTitle
46
46
SRCTermType
50
50
SRCTermTypeCode
49
49
SRCTermYear
47
47
StateReportingTermSequence
237
237
StateReportingTermYear
234
234
Powered by BI Documenter