It is
in SSIS that the integration of enterprise business data takes place where raw data
is extracted, cleansed, transformed, and loaded back to the server to be analyzed
in a complex and interactive manner before being disseminated in intelligent and
interactive ways to enable decision makers with the right kind of data, at the right
time, in a format easily understandable by them.
Creating a BI Project for SSIS in Visual Studio 2005
[ 28 ]
Resources Used for Creating Projects
In this chapter, we begin with creating a business intelligence project with SSIS
using Visual Studio 2005. In order to create such a project, it is first of all necessary
to have Visual Studio 2005 software installed on your computer. In addition, as data
on servers are accessed by the project, the computer should have access to database
servers such as SQL Server 2005, Oracle 10G XE server, SQL Anywhere 10 server,
etc., as well as other sources of data such as Microsoft Access Databases, Excel
Spread Sheet data, XML files, etc. If files and folder structures on the system are
accessed, then permissions to use them must be in place. For working with Analysis
Services, the analysis server should be accessible. It is assumed that some or all of
these resources are available.
For this chapter it is assumed that Visual Studio 2005 Standard Edition has been
installed on a computer running Windows XP with SP2. SSIS is integrated with SQL
Server 2005, hence it is assumed that SQL 2005 Server Standard Edition is installed.
Pages:
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47