Databases Reference
In-Depth Information
Figure 16-23
11. You have completed all the necessary settings in the SSIS package
to load data into a partition. Hit the F5 key to test the execution of
your SSIS package. You will see that the background colors of the
two data flow transforms Flat File Source and Partition Processing
are highlighted in yellow indicating that the SSIS package is being
executed. Along the connector line between the two transforms you
can notice the number of rows being processed. Figure 16-24 shows
a snapshot of the SSIS package execution. After all the data has
been loaded without errors you will see the background color of the
two transforms turn to green indicating successful completion of the
package. During this SSIS operation that does incremental process-
ing, Analysis Services creates a new temporary partition, loads the
data from flat file, and then merges the partition to Internet Sales
Partition 2.
 
 
Search WWH ::




Custom Search