我尝试使用导入和导出向导将数据从Analysis服务移动到SQL Server时出现错误 [英] Getting Error while I am trying to use import and export wizard to move data from Analysis service to SQL server
问题描述
您好，
-----这是我的源查询"MDX查询"来自Analysis Service
CREATE TABLE [dbo]。[AzureDashboardAS01]
（
" [帐户信息]。[TPID]。[TPID]。[MEMBER_CAPTION]]" date ，$
"[日历]。[财政月]。[财政月]。[会员资料]"日期，
" [测量]。[高于阈值ACA TPID Count]"nvarchar（max），
"[Measures]。[New Acquisition ACA TPID Count]" nvarchar（max），
" [Measures ]。[重新获取ACA TPID计数]"nvarchar（max），
"[Measures]。[Azure Customer添加失去的客户]"nvarchar（max）
）
----这是我在SQL Server中创建的基于MDX的目标表（源查询）
CREATE TABLE [dbo]。[AzureDashboardAS01]
（
" [Account信息]。[TPID]。[TPID]。[MEMBER_CAPTION]]" date，
"[日历]。[财政月]。[财政月]。[MEMBER_CAPTION]" date，
" [Measures]。[Above阈值ACA TPID计数]" nvarchar（max），
" [Measures]。[New Acquisition ACA TPID Count]" nvarchar（max），
" [Measures]。[夺回ACA TPID计数]" nvarchar（max），
" [Measures]。[Azure Customer Adds Lost Customers]" nvarchar（max）
）
和>>>>> - -----这是我的错误消息
- 预执行（错误）
消息
错误0xc0202009：数据流任务1：SSIS错误代码DTS_E_OLEDBERROR。 发生OLE DB错误。错误代码：0x80004005。
（SQL Server导入和导出向导）
错误0xc004701a：数据流任务1：源 - 查询未执行预执行阶段并返回错误代码0x80004005。
（SQL Server导入和导出向导）
信息0x4004300b：数据流任务1："目标 - AzureDashboardAS01"写了0行。
（SQL Server导入和导出向导）
* ***请让我知道如何解决这个问题！谢谢
嗨
根据我的测试，我发现虽然我会得到如上所述的错误，但我可以在表格中导入数据。我使用相应版本的SSAS OLE DB和 SQL服务器
查询，你需要确保它的语法，你可以从下面复制它
然后它应该工作（虽然它会提示下面的错误，你会得到表中的记录），我将检查这个错误，并尽快通知你
最好的问候，
Zoe Zhi
Hello ,
-----Here is my source Query "MDX Query" which is from Analysis Service
CREATE TABLE [dbo].[AzureDashboardAS01]
(
"[Account Information].[TPID].[TPID].[MEMBER_CAPTION]]" date,
"[Calendar].[Fiscal Month].[Fiscal Month].[MEMBER_CAPTION]" date,
"[Measures].[Above Threshold ACA TPID Count]" nvarchar (max),
"[Measures].[New Acquisition ACA TPID Count]" nvarchar (max),
"[Measures].[Recapture ACA TPID Count]" nvarchar (max),
"[Measures].[Azure Customer Adds Lost Customers]" nvarchar (max)
)
----Here is my destination table in SQL Server which I created based on MDX (Source Query)
CREATE TABLE [dbo].[AzureDashboardAS01]
(
"[Account Information].[TPID].[TPID].[MEMBER_CAPTION]]" date,
"[Calendar].[Fiscal Month].[Fiscal Month].[MEMBER_CAPTION]" date,
"[Measures].[Above Threshold ACA TPID Count]" nvarchar (max),
"[Measures].[New Acquisition ACA TPID Count]" nvarchar (max),
"[Measures].[Recapture ACA TPID Count]" nvarchar (max),
"[Measures].[Azure Customer Adds Lost Customers]" nvarchar (max)
)
And >>>>>------Here is my error Message
- Pre-execute (Error)
Messages
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
(SQL Server Import and Export Wizard)
Error 0xc004701a: Data Flow Task 1: Source - Query failed the pre-execute phase and returned error code 0x80004005.
(SQL Server Import and Export Wizard)
Information 0x4004300b: Data Flow Task 1: "Destination - AzureDashboardAS01" wrote 0 rows.
(SQL Server Import and Export Wizard)
****PLEASE LET ME KNOW HOW I CAN SOLVE THIS ISSUE! THANKS
Hi
Based on my test, I find that although I will get error like above, I could import the data in table. I use corresponding version of your SSAS OLE DB and SQL server
And the query, you need to make sure its syntax, you could copy it from below
Then it should be work(although it will prompt below error, you will get records in table), I will check which cuase this error , and inform you as soon as possible
Best Regards,
Zoe Zhi
这篇关于我尝试使用导入和导出向导将数据从Analysis服务移动到SQL Server时出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
