Database Reference
In-Depth Information
screen and review the three data flows that are listed in the Data Flow Task drop-down box within this tab
(Figure
2-35
). in future chapters, we show you how to create these types of tasks yourself. At this point, you are
just reviewing these to familiarize yourself with the process.
execute the SSIS package
After you have reviewed the Data Flow tasks and connections, it is time to run the package and fill the data
warehouse.
1.
while in the Control Flow tab, right-click the
LoadTablesFromFiles.dtsx
package
in the Solution Explorer and select Execute Package from the context menu (Figure
2-37
).
2.
The package will run, and all the tasks on the Control Flow designer window should
finish with a green checkmark icon (Figures
2-38
and
2-39
).
3.
Once the package has completed running, use the Debug
➤
Stop Debugging menu
option to stop the package execution (Figure
2-39
).
in this exercise, you created an SSiS project within your visual Studio solution. You then added a preexisting
package from the downloadable content included with this topic. Then you verified that the package
connections were valid, reviewed the tasks that were configured, and executed the package.
in the next exercise, you will add a premade SSAS cube project to this same visual Studio solution, so please
leave visual Studio open for now.
Creating a Cube
Great! So now, you have a data warehouse filled with data. It is time to create a cube that uses it! The most
common way to make a cube is by using the SQL Server Analysis Server (SSAS) template in Visual Studio.
Like SSIS, you can add an Analysis Server project to an existing Visual Studio solution. Do this using the
File
➤
Add
➤
New Project menu item within Visual Studio. When the Add New Project dialog window appears,
select the Analysis Server Project template from among the Business Intelligence projects, as shown in
Figure
2-44
.
