DimRelativeDayLoad
 OLE_DST Insert into Staged_dbo_DimRealtiveDay (Component)
  Properties
Property Value
Name OLE_DST Insert into Staged_dbo_DimRealtiveDay
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 94
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 Staged_dbo_DimRealtiveDay" (94)
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]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
SRCRelativeDay
310
275
SRCRelativeDayDate
312
278
SRCRelativeDayDateSK
313
281
SRCRelativeDayNumber
311
272
SRCRelativeDaySK
314
257
SRCTerm
306
260
SRCTermTitle
309
269
SRCTermTypeCode
308
266
SRCTermYear
307
263
  Output Columns
Name ID LineageID
ErrorCode
109
109
ErrorColumn
110
110
Powered by BI Documenter