Problem for DTS Import from OLAP DataSource

#1

Hi everybody:

I need help... I get the next error when i try to import data (using DTS
Wizard) from a OLAP Cube, that have a "custom rollup" dimension:

"CONTEX: ERROR CALLING OPENROWSET ON THE PROVIDER"

I am using SQL Server 2000 and "Microsoft OLE DB Provider for OLAP Services
Services 8.0"

Thanks a lot

Rodrigo

#2

Rodrigo wrote:

Quote:

Hi everybody:

I need help... I get the next error when i try to import data (using
DTS Wizard) from a OLAP Cube, that have a "custom rollup" dimension:

"CONTEX: ERROR CALLING OPENROWSET ON THE PROVIDER"

I am using SQL Server 2000 and "Microsoft OLE DB Provider for OLAP
Services Services 8.0"

Try to bind the OLAP-Source as a linked server first and after it use the
wizard to import the data.

regards

Frank
www.xax.de

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

Problem for DTS Import from OLAP DataSource

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Problem for DTS Import from OLAP DataSource - 01-25-2005 , 08:25 AM

Re: Problem for DTS Import from OLAP DataSource - 01-26-2005 , 02:38 AM