问题描述
我需要使用ESB工具包将excel格式的输入文件转换为EDI X12标准输出。此外，我必须将一些常量值传递给目标元素，这些值存储在新的 数据库（查找）下的表格中，位于
local。
我正在使用数据库查找和Value Extractor functoid，参数设置如下。
输入1 - 里程碑（源模式）值
输入2 - Connectionstring（Provider = SQLOLEDB.1; Integrated Security = SSPI ; Persist Security Info = False; Initial Catalog = BizTalkDataConfiguration; Data Source = DBServer;）
输入3 - TableName
输入4 - 键（列使用输入1）过滤器必须进行过滤的名称
此functoid的输出连接到Value Extractor functoid，其值低于输入值。
输入1 - 数据库查找functoid
输入2 - 将连接到目标模式节点的列名。
但它不返回期望的输出。请帮我解决这个问题，让我知道这个错误的原因是什么，当我在脚本功能块中尝试硬编码时，它工作正常。
在此先感谢，
Anand
Hi,
I have a requirement of transforming input file in excel format to EDI X12 standard output using ESB toolkit. Also I have to pass some constant values to destination elements, those values are stored in a table under new database (lookup) on local.
I am using Database lookup and Value Extractor functoids with the parameter settings as below.
Input 1 - Milestone (Source Schema) value
Input 2 - Connectionstring (Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=BizTalkDataConfiguration;Data Source=DBServer;)
Input 3 - TableName
Input 4 - Key (Column Name to which filter has to happen with Input 1)
And the output of this functoid is connected to Value Extractor functoid which has below input values.
Input 1 - Database lookup functoid
Input 2 - Column Name which would be connected to the destination schema node.
But it does not return the desired output. Please help me to fix this issue and let me know what will be reason for this error, when I tried hardcoding the same in scripting functoid it is working fine.
Thanks in Advance,
Anand
这篇关于数据库查找和Value Extractor functoid不返回值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！