|
![]() |
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 |
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__New] |
OpenRowsetVariable |
|
SqlCommand |
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 |
Name | ID | LineageID |
ErrorCode |
7204 |
7204 |
ErrorColumn |
7205 |
7205 |
Powered by BI Documenter |