|
![]() |
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 |
Name | Connection Manager | Description |
OleDbConnection |
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 |
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 |
Name | ID | LineageID |
ErrorCode |
7128 |
7128 |
ErrorColumn |
7129 |
7129 |
Powered by BI Documenter |