|
![]() |
Property | Value |
Name | OLE_SRC Get DimBudgeted |
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 DimBudgeted" (3782) |
Is Default Locale | True |
Pipeline Version | 0 |
Uses Dispositions | True |
Validate External Metadata | True |
Version | 7 |
Name | Connection Manager | Description |
OleDbConnection |
Name | Value |
AccessMode |
2 |
AlwaysUseDefaultCodePage |
False |
CommandTimeout |
0 |
DefaultCodePage |
1252 |
OpenRowset |
|
OpenRowsetVariable |
|
ParameterMapping |
|
SqlCommand |
SELECT BudgetedSK ,BudgetedAK ,BudgetedCode ,Budgeted ,RowIsCurrent ,RowStartDate ,RowEndDate FROM DimBudgeted WHERE RowIsCurrent = 'Y' ORDER BY BudgetedAK |
SqlCommandVariable |
Name | ID | LineageID |
Name | ID | LineageID |
Budgeted |
8621 |
8621 |
BudgetedAK |
8615 |
8615 |
BudgetedCode |
8618 |
8618 |
BudgetedSK |
8612 |
8612 |
ErrorCode |
3794 |
3794 |
ErrorColumn |
3795 |
3795 |
RowEndDate |
8048 |
8048 |
RowIsCurrent |
8683 |
8683 |
RowStartDate |
8045 |
8045 |
Budgeted |
8620 |
8620 |
BudgetedAK |
8614 |
8614 |
BudgetedCode |
8617 |
8617 |
BudgetedSK |
8611 |
8611 |
RowEndDate |
8047 |
8047 |
RowIsCurrent |
8682 |
8682 |
RowStartDate |
8044 |
8044 |
Powered by BI Documenter |