使用SSIS将数据从Cube中导出到关系型数据库

关键字：Cube，导出，关系型数据库，sqlserver

 

      实际工作中，可能遇到某些场景，需要把做好的Cube里面的数据，导出到sqlserver等等数据库中。这个时候问题就出现了，Cube存的是所谓的多维数据，但是关系型数据库中存的是二维数据表，当执行这个操作的时候（SSIS），就会报错：

 

SSIS package "Package1.dtsx" starting.

Information: 0x4004300A at Data Flow Task 1, SSIS.Pipeline:Validation phase is beginning.

Warning: 0x8020400D at Data Flow Task 1, Source - Query [1]:The output "OLE DB Source Output" (11) references an external datatype that cannot be mapped to a Data Flow task data type. The Data Flow taskdata type DT_WSTR will be used instead.

Warning: 0x80049304 at Data Flow Task 1, SSIS.Pipeline:Warning: Could not open global shared memory to communicate with performanceDLL; data flow performance counters are not available.  To resolve, runthis package as an administrator, or on the system's console.

Information: 0x40043006