|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_SRC Term |
| Description | OLE DB Source |
| Up Stream Components | none |
| Down Stream Components | |
| ID | 1 |
| 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" (1) |
| Is Default Locale | True |
| Pipeline Version | 0 |
| Uses Dispositions | True |
| Validate External Metadata | True |
| Version | 7 |
Connections
| Name | Connection Manager | Description |
OleDbConnection |
Custom Properties
| Name | Value |
AccessMode |
2 |
AlwaysUseDefaultCodePage |
False |
CommandTimeout |
0 |
DefaultCodePage |
1252 |
OpenRowset |
|
OpenRowsetVariable |
|
ParameterMapping |
|
SqlCommand |
SELECT StagedTermSK ,TermAK as SRCTermAK ,TermStartDate as SRCTermStartDate ,TermEndDate as SRCTermEndDate ,TermTitle as SRCTermTitle ,AcademicYearCode as SRCAcademicYearCode ,AcademicYear as SRCAcademicYear ,TermYear as SRCTermYear ,TermTypeCode as SRCTermTypeCode ,TermType as SRCTermType ,ActiveTerm as SRCActiveTerm ,DefaultTerm as SRCDefaultTerm ,RelativeDay as SRCRelativeDay ,PriorYearTerm as SRCPriorYearTerm ,StateReportingTermYear as SRCStateReportingTermYear ,StateReportingTermSequence as SRCStateReportingTermSequence FROM [Staged_dbo_DimTerm] order by TermAK |
SqlCommandVariable |
User::SQLTermSource |
Input Columns
| Name | ID | LineageID |
Output Columns
| Name | ID | LineageID |
ErrorCode |
13 |
13 |
ErrorColumn |
14 |
14 |
SRCAcademicYear |
1330 |
1330 |
SRCAcademicYearCode |
1327 |
1327 |
SRCActiveTerm |
1342 |
1342 |
SRCDefaultTerm |
1345 |
1345 |
SRCPriorYearTerm |
1370 |
1370 |
SRCRelativeDay |
1348 |
1348 |
SRCStateReportingTermSequence |
1532 |
1532 |
SRCStateReportingTermYear |
1529 |
1529 |
SRCTermAK |
1315 |
1315 |
SRCTermEndDate |
1321 |
1321 |
SRCTermStartDate |
1318 |
1318 |
SRCTermTitle |
1324 |
1324 |
SRCTermType |
1339 |
1339 |
SRCTermTypeCode |
1336 |
1336 |
SRCTermYear |
1333 |
1333 |
StagedTermSK |
1312 |
1312 |
SRCAcademicYear |
1329 |
1329 |
SRCAcademicYearCode |
1326 |
1326 |
SRCActiveTerm |
1341 |
1341 |
SRCDefaultTerm |
1344 |
1344 |
SRCPriorYearTerm |
1369 |
1369 |
SRCRelativeDay |
1347 |
1347 |
SRCStateReportingTermSequence |
1531 |
1531 |
SRCStateReportingTermYear |
1528 |
1528 |
SRCTermAK |
1314 |
1314 |
SRCTermEndDate |
1320 |
1320 |
SRCTermStartDate |
1317 |
1317 |
SRCTermTitle |
1323 |
1323 |
SRCTermType |
1338 |
1338 |
SRCTermTypeCode |
1335 |
1335 |
SRCTermYear |
1332 |
1332 |
StagedTermSK |
1311 |
1311 |
| Powered by BI Documenter |
