Loading data from a flat file directly to cube in AS 2005

#1

I want to load data from a flat file which is well formed no data
quality issues
directly to a cube in AS 2005.

Please let me know how this can be done.

Thanks
Karen

#2

How about using SSIS?

For example, the Partition Processing destination loads and processes an SQL
Server 2005 Analysis Services (SSAS) partition.

http://msdn2.microsoft.com/en-gb/library/ms137992.aspx

Ohjoo

"KarenM" <karenmiddleol (AT) yahoo (DOT) com> wrote

Quote:

I want to load data from a flat file which is well formed no data
quality issues
directly to a cube in AS 2005.

Please let me know how this can be done.

Thanks
Karen

#3

Ok the question I had was I want to use flat file as a data source to
SSAS 2005 even if it means using SSIS. But I do not want to stage the
data in the database.

Thanks
Karen
Ohjoo Kwon wrote:

Quote:

How about using SSIS?

For example, the Partition Processing destination loads and processes an SQL
Server 2005 Analysis Services (SSAS) partition.

http://msdn2.microsoft.com/en-gb/library/ms137992.aspx

Ohjoo

"KarenM" <karenmiddleol (AT) yahoo (DOT) com> wrote in message
news:1166349168.828176.307740 (AT) n67g2000cwd (DOT) googlegroups.com...
I want to load data from a flat file which is well formed no data
quality issues
directly to a cube in AS 2005.

Please let me know how this can be done.

Thanks
Karen

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

Loading data from a flat file directly to cube in AS 2005

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

Loading data from a flat file directly to cube in AS 2005 - 12-17-2006 , 03:52 AM

Re: Loading data from a flat file directly to cube in AS 2005 - 12-17-2006 , 09:07 AM

Re: Loading data from a flat file directly to cube in AS 2005 - 12-17-2006 , 08:06 PM