Options dialog again appears.
Address into the Name box on the General tab.
Click the Source
to select it, if necessary, to the right hand side.
Click the Destinations
to cause it to appear in the Selected Columns space to the right of the
return to the Transform Data Task Properties dialog, which appears as
depicted in Illustration 24 with our additions.
24: The Transform Data Task Properties Dialog - With Added Transformation
the new transformation's mapping line is selected, click the Test button.
of a successful test is returned.
Click the View
Results button to obtain the sample data set shown in Illustration 25.
25: The View Data Dialog with Results
to close the View Data dialog.
to close the Testing Transformation dialog.
returned once again to the Transformations tab.
dialog closes, and we
are returned to the Select
DTS Package: <New Package> window, once again.
-> Save As to save our work up
until now, and to give the package a name.
Server Access Log to Web Analysis into the Package Name box.
Type in /
select the appropriate Server name in the Server selector box.
appropriate authentication information, as we did earlier.
As dialog resembles that shown in Illustration 26.
26: The Save As Dialog
execute the package, and then navigate to the table that it creates to
ascertain that our package has delivered the expected results.
-> Execute from the main menu.
progress is metered as the Executing DTS Package dialog appears, and
then the Package Execution Results message box reports the successful
execution of the package, as shown in Illustration 27.
27: The Save As Dialog