Re: ETL Best Practice question

#1

Hi,

Can you kindly explain why it requires Office 2003?
Will it not work if I have office 97?

Thanks.

Quote:

It requires SQL Server 2000 and Office 2003, but it is essentially a free
download. You should be able to download the first couple of chapters of
the prescriptive architecture guide that describe the requirements without
downloading the complete Accelerator.

If you download the Accelerator, there are a couple of sample schemas that
ship with it. One supports Sales and Marketing and the other supports
Retail. These are just "samples" that will allow you to generate the
solution and look at the components produced. The rest of the PAG (which
you get when you install the Accelerator) documents the entire solution.
Again, many of the recommendations that we have for best practices are
included in the solution.

Hope that helps.

--
Sean

--
Sean Boon
SQL Server BI Product Unit

#2

Don't think it will...

It uses macro programming in the excel sheet which automatically creates a
total environment in SQL and AS - don't think you can
register the libraryr needed for this in an elderly office version.

It will tell you when trying to install....

\Michael Vardinghus

Learner <wantnospam (AT) email (DOT) com> wrote

Quote:

Hi,

Can you kindly explain why it requires Office 2003?
Will it not work if I have office 97?

Thanks.

It requires SQL Server 2000 and Office 2003, but it is essentially a
free
download. You should be able to download the first couple of chapters
of
the prescriptive architecture guide that describe the requirements
without
downloading the complete Accelerator.

If you download the Accelerator, there are a couple of sample schemas
that
ship with it. One supports Sales and Marketing and the other supports
Retail. These are just "samples" that will allow you to generate the
solution and look at the components produced. The rest of the PAG
(which
you get when you install the Accelerator) documents the entire solution.
Again, many of the recommendations that we have for best practices are
included in the solution.

Hope that helps.

--
Sean

--
Sean Boon
SQL Server BI Product Unit

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: ETL Best Practice question

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: ETL Best Practice question - 04-06-2004 , 11:21 AM

Re: ETL Best Practice question - 04-06-2004 , 02:10 PM