OLE_SRC Get DimChartOfAccount - Component

Properties

Property	Value
Name	OLE_SRC Get DimChartOfAccount
Description	OLE DB Source
Up Stream Components	none
Down Stream Components	TF_SCD DimChartOfAccount
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 DimChartOfAccount" (3782)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	True
Validate External Metadata	True
Version	7

Connections

Name	Connection Manager	Description
OleDbConnection	EnterpriseDW

Custom Properties

Name	Value
AccessMode	2
AlwaysUseDefaultCodePage	False
CommandTimeout	0
DefaultCodePage	1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand	SELECT GlAccountSK ,YearGlAccountNumberAK ,GlAccountNumber ,FiscalYear ,AccountStatusCode ,AccountStatus ,StartDate ,EndDate ,IsAccountBudgeted ,BudgetPoolNo ,RowIsCurrent ,RowStartDate ,RowEndDate FROM DimChartOfAccount WHERE RowIsCurrent = 'Y' ORDER BY YearGlAccountNumberAK
SqlCommandVariable

Input Columns

Name

ID

LineageID

Output Columns

Name	ID	LineageID
AccountStatus	7310	7310
AccountStatusCode	7307	7307
BudgetPoolNo	7316	7316
EndDate	6605	6605
ErrorCode	3794	3794
ErrorColumn	3795	3795
FiscalYear	7304	7304
GlAccountNumber	7301	7301
GlAccountSK	7295	7295
IsAccountBudgeted	7313	7313
RowEndDate	6614	6614
RowIsCurrent	6608	6608
RowStartDate	6611	6611
StartDate	6602	6602
YearGlAccountNumberAK	7298	7298
AccountStatus	7309	7309
AccountStatusCode	7306	7306
BudgetPoolNo	7315	7315
EndDate	6604	6604
FiscalYear	7303	7303
GlAccountNumber	7300	7300
GlAccountSK	7294	7294
IsAccountBudgeted	7312	7312
RowEndDate	6613	6613
RowIsCurrent	6607	6607
RowStartDate	6610	6610
StartDate	6601	6601
YearGlAccountNumberAK	7297	7297

Powered by BI Documenter