While executing a package, you must make use of
the Data Viewer diagnostic tool. You will be using data viewers in Chapters 6, 8, 9,
and 10.
Summary
In this chapter, we described the role played by SSIS in improving the productivity
of enterprise business. The arsenal of tools available for the package designer using
the VS 2005 IDE is described. As a major portion of the tasks are related to data, the
objects participating in the data flow are described in greater detail.
Creating a BI Project for
SSIS in Visual Studio 2005
The previous chapter described several key objects in the SSIS toolbox. This chapter
completes the picture by describing how a business intelligence project for SSIS is
created using Visual Studio 2005 IDE. It is important to know how such a project is
created, and understand the details of the various menus, objects, and windows that
are displayed, and their role in package design. Although somewhat overwhelming,
you will get used to the various details as you work through the chapters. Hands-on
exercises should help you in creating, renaming, saving, and importing packages.
Business Intelligence using
Microsoft Products
Microsoft provides an integrated business intelligence suite of applications that
offers enterprises end-to-end support, starting with its three-piece suite??”Integration
Services, Analysis Services, and Reporting Services. Excel applications, Share
Point server, and Office 12 suite gives it a further boost by tight integration.
Pages:
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46