DimOrgUnitLoad
 OLE_DST Load SCD1 Temp table for Org Units (Component)
  Properties
Property Value
Name OLE_DST Load SCD1 Temp table for Org Units
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 7113
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 SCD1 Temp table for Org Units" (7113)
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_DimOrgUnit__Type1Update]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
BudgetManager
7178
7003
BudgetManagerId
7177
7002
ControlOrgUnit
7175
7000
ControlOrgUnitName
7176
7001
EndDate
7188
7013
FunctionCode
7168
6993
FunctionDescription
7169
6994
Fund
7167
6992
FundCode
7166
6991
Location
7173
6998
LocationCode
7172
6997
OrgUnit
7162
6987
OrgUnitAK
7161
6986
OrgUnitGrouping
7186
7011
OrgUnitName
7163
6988
OrgUnitSK
7160
6985
OrgUnitStatus
7165
6990
OrgUnitStatusCode
7164
6989
PrincipalAdmin
7182
7007
PrincipalAdminId
7181
7006
ProjectNumber
7183
7008
Qual1
7174
6999
ReportDistribution
7185
7010
ReportDistributionCode
7184
7009
StartDate
7187
7012
StateOrgUnit
7324
7313
SubFunction
7171
6996
SubFunctionCode
7170
6995
UserGroup
7180
7005
UserGroupId
7179
7004
  Output Columns
Name ID LineageID
ErrorCode
7128
7128
ErrorColumn
7129
7129
Powered by BI Documenter