Database Reference
In-Depth Information
11.
Click the Mappings page to force the XMl to be written properly in the .dtsx file and
verify that the mappings look logically correct.
12.
Right click the data flow design surface and choose Execute Task from the context
menu (similar to Figure
8-18
).
13.
when the task is complete, stop Visual studio's debugger and verify that the task ran
successfully or troubleshoot any errors and try again.
14.
open sQl server Management studio and verify that dimstores has data in it.
Configure the Fill DimPublishers Data Flow Task
dimPublishers is next on the list. let's tackle it now.
1.
navigate to the data Flow tab and select the Fill dimPublishers data Flow Task from
the data Flow Task dropdown box.
2.
Add an olE dB data source to the data flow surface. Rename it to get Publishers
data olE dB source.
locate the comment
-- 2c) Get source data from pubs.dbo.
publishers in
the sQl code file and review the code beneath it. The code should look like listing 8-3.
3.
Listing 8-3.
SQL Code from pubs.dbo.publishers
Select
[PublisherId]=Cast( pub_id as nChar(4) )
, [PublisherName]=Cast( pub_name as nVarchar(50) )
From pubs.dbo.publishers
4.
Add this code to the sQl command text code area of the olE dB data source
(similar to Figure
8-8
).
5.
Click the Preview button to verify that the query worked successfully.
6.
Click the Columns page to force the XMl to be written properly in the .dtsx file.
7.
Close the olE dB source Editor window by clicking the oK button.
8.
Add an olE dB data destination to the data flow surface. Rename it to Fill
dimPublishers olE dB destination.
9.
Connect the data flow path from the data source to the data destination.
10.
Edit the olE dB data destination so that it imports data to the dimPublishers table
(similar to Figure
8-14
)
11.
Click the Mappings page to force the XMl to be written properly in the .dtsx file and
verify that the mappings look logically correct.
12.
Right click the data flow design surface and choose Execute Task from the context
menu (similar to Figure
8-18
).
