Database Reference
In-Depth Information
eXerCISe 8-2. teStING YOUr SSIS paCKaGe
in this exercise, you will test that the entire package works as expected by resetting the database and
executing the package.
reset the Database Objects Before testing Your etL process
1.
locate the Create dwPubssales script.sql file in Visual studio. You should find this
file under the dwPubssales solution folder you created in Exercise 5-4.
2.
open this file and execute its code. You can do this by right-clicking an empty area
in the sQl code window to bring up the context menu and select Execute sQl. You
may remember doing this back in Chapter 2 (Figure 2-15).
3.
A Connect to database Engine dialog box will appear. Type in you server name and
click the Connect button.
4.
in a few seconds, you should receive a message stating “The dwPubssales data
warehouse is now created.”
testing Your SSIS package
now it is time to execute the entire ssis package to verify that it runs as a unit.
1.
in solution Explorer, right-click your ssis package called
ETlProcessFordwPubssales.dtsx and select Execute Task from the context menu,
as shown in Figure 8-24 . Visual studio will launch this Execute sQl task with its
debugging engine.
2.
when the task is complete, stop Visual studio's debugger and verify that the task ran
successfully or troubleshoot any errors and try again. it should look like Figure 8-25 .
3.
open sQl server Management studio and verify that all the tables have data in
them. You can use the code from listing 8-10.
Listing 8-10. SQL Code to Verify DWPubSales' Table Data
Select Top 100 * from dbo.DimAuthors
Select Top 100 * from dbo.DimStores
Select Top 100 * from dbo.DimPublishers
Select Top 100 * from dbo.DimDates
Select Top 100 * from dbo.DimTitles
Select Top 100 * from dbo.FactSales
Select Top 100 * from dbo.FactTitlesAuthors
4.
once you have verified that the data is loaded, create a backup of the database in its
filled state using the code in listing 8-11.
 
Search WWH ::




Custom Search