DimOrgUnitLoad
 OLE_DEST Load Verification table Org Unit Operations (Component)
  Properties
Property Value
Name OLE_DEST Load Verification table Org Unit Operations
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 1745
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_DEST Load Verification table Org Unit Operations" (1745)
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].[Verify_dbo_DimOrgUnit]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
BudgetManager
1811
1879
BudgetManagerId
1810
1876
ControlOrgUnit
1808
1870
ControlOrgUnitName
1809
1873
EndDate
1821
1909
FunctionCode
1801
1849
FunctionDescription
1802
1852
Fund
1800
1846
FundCode
1799
1843
Location
1806
1864
LocationCode
1805
1861
OrgUnit
1795
1831
OrgUnitAK
1794
1828
OrgUnitGrouping
1819
1903
OrgUnitName
1796
1834
OrgUnitStatus
1798
1840
OrgUnitStatusCode
1797
1837
PrincipalAdmin
1815
1891
PrincipalAdminId
1814
1888
ProjectNumber
1816
1894
Qual1
1807
1867
ReportDistribution
1818
1900
ReportDistributionCode
1817
1897
RowIsDuplicate
1822
552
RowIsSelected
1823
555
StartDate
1820
1906
StateOrgUnit
1917
1914
SubFunction
1804
1858
SubFunctionCode
1803
1855
UserGroup
1813
1885
UserGroupId
1812
1882
  Output Columns
Name ID LineageID
ErrorCode
1760
1760
ErrorColumn
1761
1761
Powered by BI Documenter