|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_SRC Get DimStudentReceipt |
| Description | OLE DB Source |
| Up Stream Components | none |
| Down Stream Components | |
| ID | 3782 |
| 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 Get DimStudentReceipt" (3782) |
| 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 StudentReceiptSK ,StudentReceiptAK ,StudentId ,PrintedReceiptNumber ,ReceiptCategory ,ReceiptProcesserCode ,ReceiptProcesser ,SessionDate ,SessionSequenceNumber ,ReceiptSequenceNumber ,ReceiptTypeCode ,ReceiptType ,MiscellaneousReceiptCatecoryCode ,MiscellaneousReceiptCategory ,ReceiptReference ,RowIsCurrent ,RowStartDate ,RowEndDate FROM DimStudentReceipt WHERE RowIsCurrent = 'Y' ORDER BY StudentReceiptAK |
SqlCommandVariable |
Input Columns
| Name | ID | LineageID |
Output Columns
| Name | ID | LineageID |
ErrorCode |
3794 |
3794 |
ErrorColumn |
3795 |
3795 |
MiscellaneousReceiptCatecoryCode |
7060 |
7060 |
MiscellaneousReceiptCategory |
7063 |
7063 |
PrintedReceiptNumber |
7033 |
7033 |
ReceiptCategory |
7036 |
7036 |
ReceiptProcesser |
7042 |
7042 |
ReceiptProcesserCode |
7039 |
7039 |
ReceiptReference |
7066 |
7066 |
ReceiptSequenceNumber |
7051 |
7051 |
ReceiptType |
7057 |
7057 |
ReceiptTypeCode |
7054 |
7054 |
RowEndDate |
7075 |
7075 |
RowIsCurrent |
7069 |
7069 |
RowStartDate |
7072 |
7072 |
SessionDate |
7045 |
7045 |
SessionSequenceNumber |
7048 |
7048 |
StudentId |
7030 |
7030 |
StudentReceiptAK |
7027 |
7027 |
StudentReceiptSK |
7024 |
7024 |
MiscellaneousReceiptCatecoryCode |
7059 |
7059 |
MiscellaneousReceiptCategory |
7062 |
7062 |
PrintedReceiptNumber |
7032 |
7032 |
ReceiptCategory |
7035 |
7035 |
ReceiptProcesser |
7041 |
7041 |
ReceiptProcesserCode |
7038 |
7038 |
ReceiptReference |
7065 |
7065 |
ReceiptSequenceNumber |
7050 |
7050 |
ReceiptType |
7056 |
7056 |
ReceiptTypeCode |
7053 |
7053 |
RowEndDate |
7074 |
7074 |
RowIsCurrent |
7068 |
7068 |
RowStartDate |
7071 |
7071 |
SessionDate |
7044 |
7044 |
SessionSequenceNumber |
7047 |
7047 |
StudentId |
7029 |
7029 |
StudentReceiptAK |
7026 |
7026 |
StudentReceiptSK |
7023 |
7023 |
| Powered by BI Documenter |
