在ole db源任务中使用mdx运行变量时出错 [英] Error while running variable with mdx in ole db source task

问题描述

Hi,

 我正在从Oledb连接到Cube，以获取某些季度的数据在一年。在我写一个for来获取每个季度值并将值传递给具有此用户定义值的MDX查询时。在ole db任务中，我从变量中选择了sql命令，其中
i分配给用户定义的值。到目前为止，它正在显示用于映射到ado.net目标的列。一旦我运行该应用程序，将显示以下错误。甚至尝试了很多'延迟验证=真'等等。请做一些。

 I'm connecting to Cube from Oledb, to fetch data for some quarters in year. While doing i write a for to get each quarter value and pass the value to the MDX query with this user defined value. In ole db task, i selected sql command from variable, which i assigned to the user defined value. Till now its fine, columns are showing for mapping to ado.net destination. once i run the application, below error is displaying. Even tried lot of 'Delay Validation = true' and so on. Please do needful.

[OLE DB源[58]]错误：SSIS错误代码DTS_E_OLEDBERROR。 发生OLE DB错误。错误代码：0x80004005。

[OLE DB Source [58]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

[SSIS.Pipeline]错误：OLE DB源在预执行阶段失败并返回错误代码0x80004005。

[SSIS.Pipeline] Error: OLE DB Source failed the pre-execute phase and returned error code 0x80004005.

推荐答案

你好HappyCoding54，

Hi HappyCoding54,

错误可能来自其中一个动态部分，可能是一个驱动的表达式连接或循环。

The error is probably coming from one of the dynamic parts as perhaps an expression that drives the connection, or loop.

如果没有更多技术细节，并且错误非常通用，则无法再为您提供帮助。

Without more technical details, and the error being very generic it is not possible to help you any further.

这篇关于在ole db源任务中使用mdx运行变量时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！