|
![]() |
Property | Value |
Name | DFT Load Temp Staged Term from Staging |
Description | Data Flow Task |
Precedence Executables | none |
Contrained Executables | none |
ID | 96fa5107-c304-41eb-b4be-b3aaedab7dd3 |
BLOB Temp Storage Path | |
Buffer Temp Storage Path | |
Default Buffer Max Rows | 10000 |
Default Buffer Size | 10485760 |
Run In Optimized Mode | True |
Locale ID | English (United States) |
Logging Mode | UseParentSetting |
Forced Execution Value | 0 |
Force Execution Value | False |
Delay Validation | False |
Disable | False |
Disable Event Handlers | False |
Fail Package On Failure | False |
Fail Parent On Failure | False |
Maximum Error Count | 1 |
Isolation Level | Serializable |
Suspend Required | False |
Transaction Option | Supported |
Name | Type | Description |
10 |
OLE DB Destination |
|
9 |
OLE DB Source |
|
12 |
The case transformation corrects, cases and standardizes names, addresses or any text to proper case for any input columns data. |
Component | Input Column | Destination Column | |
OLE_DST Insert into Staged_dbo_DimRealtiveDay |
|||
OLE DB Destination Input |
|||
SRCRelativeDay [?] |
![]() |
RelativeDay |
|
SRCRelativeDayDate [?] |
![]() |
RelativeDayDate |
|
SRCRelativeDayDateSK [?] |
![]() |
RelativeDayDateSK |
|
SRCRelativeDayNumber [?] |
![]() |
RelativeDayNumber |
|
SRCRelativeDaySK [?] |
![]() |
RelativeDaySK |
|
SRCTerm [?] |
![]() |
Term |
|
SRCTermTitle [?] |
![]() |
TermTitle |
|
SRCTermTypeCode [?] |
![]() |
TermTypeCode |
|
SRCTermYear [?] |
![]() |
TermYear |
|
TF Case Transform |
|||
Name Parse Input |
|||
SRCRelativeDay [?] |
![]() |
SRCRelativeDay |
|
SRCRelativeDayDate [?] |
![]() |
SRCRelativeDayDate |
|
SRCRelativeDayDateSK [?] |
![]() |
SRCRelativeDayDateSK |
|
SRCRelativeDayNumber [?] |
![]() |
SRCRelativeDayNumber |
|
SRCRelativeDaySK [?] |
![]() |
SRCRelativeDaySK |
|
SRCTerm [?] |
![]() |
SRCTerm |
|
SRCTermTitle [?] |
![]() |
SRCTermTitle |
|
SRCTermTypeCode [?] |
![]() |
SRCTermTypeCode |
|
SRCTermYear [?] |
![]() |
SRCTermYear |
Name | Value | Description |
Powered by BI Documenter |