Database Reference
In-Depth Information
, [YearName]=Cast('Unknown Year' as nVarchar(50) )
Union
Select
[DateKey]=-2
, [Date]=Cast('01/01/1900' as nVarchar(50) )
, [DateName]=Cast('Corrupt Day' as nVarchar(50) )
, [Month]=-2
, [MonthName]=Cast('Corrupt Month' as nVarchar(50) )
, [Quarter]=-2
, [QuarterName]=Cast('Corrupt Quarter' as nVarchar(50) )
, [Year]=-2
, [YearName]=Cast('Corrupt Year' as nVarchar(50) )
Set Identity_Insert [DWPubsSales].[dbo].[DimDates] Off
2.
Highlight this code, right-click it, and choose Copy from the context menu.
3.
navigate to the Control Flow tab and select the Add null date lookup Values Execute
sQl Task.
4.
Edit the Add null date lookup Values Execute sQl Task by right-clicking the task
and selecting Edit from the context menu.
5.
select the Connection property. A dropdown box appears in the dialog window that
will let you configure this property.
6.
Configure the Connection property by selecting the option dwPubssales from the
dropdown box (Figure
8-21
).
Figure 8-21.
Configuring the Add Null Dates Lookup Values Execute SQL Task
7.
select the sQl statement property. An ellipsis button appears in the dialog window
that will let you configure this property.
8.
Configure the sQl statement property by clicking the ellipsis button and pasting
the code from listing 8-5 that you copied earlier into the Enter sQl Query dialog
window that appears (Figure
8-21
).
