DimGlCodeLoad
 OLE_DST Load New Temp table for Gl Codes (Component)
  Properties
Property Value
Name OLE_DST Load New Temp table for Gl Codes
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 7718
Component Class ID {5A0B62E8-D91D-49F5-94A5-7BE58DE508F0}
Contact Info OLE DB Destination;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4
Identification String component "OLE_DST Load New Temp table for Gl Codes" (7718)
Is Default Locale True
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 4
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
AccessMode
3
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
FastLoadKeepIdentity
False
FastLoadKeepNulls
False
FastLoadMaxInsertCommitSize
2147483647
FastLoadOptions
TABLOCK,CHECK_CONSTRAINTS
OpenRowset
[dbo].[Staged_dbo_DimGlCode__New]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
AccountSign
7800
7608
Glc
7788
7596
GlCategory
7793
7601
GlCategoryCode
7792
7600
GlcDescription
7796
7604
GlClass
7791
7599
GlClassCode
7790
7598
GlCodeAK
7787
7595
GlCodeName
7797
7605
GlCodeSubTotal
7799
7607
GlCodeSubTotalCode
7798
7606
GlGroup
7892
7883
GlSubCategory
7795
7603
GlSubCategoryCode
7794
7602
HrClassification
8027
8009
HrTimeStatus
8028
8010
Qual2
7789
7597
RowEndDate
7786
7593
RowIsCurrent
7784
7591
RowStartDate
7785
7592
  Output Columns
Name ID LineageID
ErrorCode
7733
7733
ErrorColumn
7734
7734
Powered by BI Documenter