嗨 

根据我的测试，我发现虽然我会得到如上所述的错误，但我可以在表格中导入数据。我使用相应版本的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