0x80040e51说明：“提供程序无法导出参数信息，并且尚未调用SetParameterInfo。”(0x80040e51 Description: “Provider cannot derive parameter information and SetParameterInfo has not been called.”)

 我正在尝试使用where子句执行对oracle的查询 
 
BETWEEN date AND date2
 
 第一轮研究表明，Oracle OLEDB提供程序不允许参数化查询，并且这些应该在变量中设置。 所以我创建了3个变量。 2来保存我正确填充的日期，并且一个保存查询，并且结尾的表达式为： 
 
 BETWEEN to_date('" + (DT_WSTR, 30)@[User::lastRun]  + "','DD/MM/YYYY HH:MI:SS AM') AND to_date('" + (DT_WSTR, 30) @[User::thisRun] + "','DD/MM/YYYY HH:MI:SS AM')"
 
 当我在表达式构建器中单击“评估表达式”时，它会正确评估 
 
BETWEEN to_date('1/1/1900','DD/MM/YYYY HH:MI:SS AM') AND
to_date('1/1/2010','DD/MM/YYYY HH:MI:SS AM')
 
 而且我能够使用其他工具成功地运行这个预测。 
 
 但是当我尝试运行包时，我收到： 
 
 
 
 [mySource 1 ]错误：SSIS错误代码DTS_E_OLEDBERROR。 发生了OLE DB错误。 错误代码：0x80040E51。 OLE DB记录可用。 来源：“OraOLEDB”Hresult：0x80040E51描述：“提供程序无法派生参数信息，并且尚未调用SetParameterInfo”。 
 
 
 mySource是OLE DB源的地方。 它的AccessMode被设置为“来自变量的SQL命令”并将SQLCommandVariable设置为我的查询变量。 
 
 我也尝试手动设置所有输出外部列，并更改我在查询中选择的一些值以抛弃oracle DATE数据类型： 
 
to_char(PT.CREATED_DTTM,'DD/MM/YYYY HH:MI:SS AM')
 
 对于SSIS我还是个新手，所以我甚至不确定我是否在正确的位置寻找这个错误的根源。 任何人有想法何去何从？ 
 
 截图请求。 正如你可以看到“从变量”查询在预览模式下按预期工作，但是当我尝试执行它时，我得到错误。 
 

I am trying to execute a query against oracle with the where clause including 
 
BETWEEN date AND date2
 
First round of research shows that the oracle OLEDB provider does not allow for parameterized queries, and these should be set in variables. So I have created 3 variables. 2 to hold my dates that are populated correctly, and one to hold the query with the expression ending in: 
 
 BETWEEN to_date('" + (DT_WSTR, 30)@[User::lastRun]  + "','DD/MM/YYYY HH:MI:SS AM') AND to_date('" + (DT_WSTR, 30) @[User::thisRun] + "','DD/MM/YYYY HH:MI:SS AM')"
 
When I click "Evaluate Expression" in the expression builder, it evaluates correctly to
 
BETWEEN to_date('1/1/1900','DD/MM/YYYY HH:MI:SS AM') AND
to_date('1/1/2010','DD/MM/YYYY HH:MI:SS AM')
 
And I am able to run this against oracle successfully using other tools.
 
But when I try to run the package, I receive:
 
 
 
[mySource 1] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E51. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E51 Description: "Provider cannot derive parameter information and SetParameterInfo has not been called.".
 
 
Where mySource is the OLE DB Source. It has it's AccessMode set to "SQL Command From Variable" and SQLCommandVariable set to my query variable.
 
I also tried manually setting all of the Output external columns, and changing some of the values I was selecting in the query to cast away the oracle DATE datatype: 
 
to_char(PT.CREATED_DTTM,'DD/MM/YYYY HH:MI:SS AM')
 
I'm still pretty new to SSIS, so I am not even sure I am looking in the correct place for the root of this error. Anyone have ideas where to go from here?
 
Screenshots as requested. As you can see the "from variable" query works as expected in preview mode, but when I try to execute it I get the error.
 
  

原文：https://stackoverflow.com/questions/10416875