DimOrgUnitLoad
 OLE_DST Load New Temp table for OrgUnits (Component)
  Properties
Property Value
Name OLE_DST Load New Temp table for OrgUnits
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 7189
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 OrgUnits" (7189)
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__New]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
BudgetManager
7255
6937
BudgetManagerId
7254
6936
ControlOrgUnit
7252
6934
ControlOrgUnitName
7253
6935
EndDate
7265
6947
FunctionCode
7245
6927
FunctionDescription
7246
6928
Fund
7244
6926
FundCode
7243
6925
Location
7250
6932
LocationCode
7249
6931
OrgUnit
7239
6921
OrgUnitAK
7238
6920
OrgUnitGrouping
7263
6945
OrgUnitName
7240
6922
OrgUnitStatus
7242
6924
OrgUnitStatusCode
7241
6923
PrincipalAdmin
7259
6941
PrincipalAdminId
7258
6940
ProjectNumber
7260
6942
Qual1
7251
6933
ReportDistribution
7262
6944
ReportDistributionCode
7261
6943
RowEndDate
7268
6950
RowIsCurrent
7266
6948
RowStartDate
7267
6949
StartDate
7264
6946
StateOrgUnit
7326
7309
SubFunction
7248
6930
SubFunctionCode
7247
6929
UserGroup
7257
6939
UserGroupId
7256
6938
  Output Columns
Name ID LineageID
ErrorCode
7204
7204
ErrorColumn
7205
7205
Powered by BI Documenter