DimRelativeDayLoad
 OLE_DST Insert into Temp Relative Day SCD1 (Component)
  Properties
Property Value
Name OLE_DST Insert into Temp Relative Day SCD1
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 926
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 Insert into Temp Relative Day SCD1" (926)
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_DimRelativeDay__Type1Update]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
RelativeDay
1600
1378
RelativeDayDate
1604
1467
RelativeDayDateSK
1605
1468
RelativeDayNumber
1603
1466
RelativeDaySK
1601
1464
Term
1602
1465
TermTitle
1597
1188
TermTypeCode
1599
1192
TermYear
1598
1191
  Output Columns
Name ID LineageID
ErrorCode
941
941
ErrorColumn
942
942
Powered by BI Documenter