Database Reference
In-Depth Information
5.
Edit the Fill dimdates Execute sQl Task by right-clicking the task and selecting Edit
from the context menu.
6.
select the Connection property. A dropdown box appears in the dialog window that
will let you configure this property.
7.
Configure the Connection property by selecting the option dwPubssales from the
dropdown box, as shown in Figure
8-19
.
Figure 8-19.
Configuring the Fill DimDates Execute SQL Task
8.
select the sQl statement property. An ellipsis button appears in the dialog window
that will let you configure this property.
9.
Configure the sQl statement property by clicking the ellipsis button and pasting
the code from listing 8-4 (that you copied earlier) into the Enter sQl Query dialog
window that appears (Figure
8-19
).
10.
Remove any sQl go statements from your code. sQl go statements will cause the
Execute sQl Task to fail.
11.
Click the oK button to close the Enter sQl Query dialog window.
12.
Click the oK button to close the Execute sQl Task editor.
