Excel连接始终在通过Job运行时查找文件模板 [英] Excel connection always looking for File template while running through Job
问题描述
大家好,
我正在从excel文件中读取数据。
I am reading data from excel file.
现在在开发过程中我使用了A.XLSX文件相关的连接字符串。
Now during development I have used A.XLSX file used related connectionstring.
现在当我转向生产时,我没有A.xlsx文件存在,因为我通过变量传递Name.But包总是试图绑定A.XLSX。
Now when I move to production, I don't have A.xlsx file exist as I am passing Name through variable.But Package always intitally tried to bind A.XLSX.
那么我是否需要始终将A.xlsx文件作为模板保存在文件夹中?
So Do I need to Keep always A.xlsx file in the folder as a template ?
推荐答案
创建2个参数文件路径和文件名并将其作为 表达式传递给连接管理器,以便在运行时动态选择路径和文件名。
Create 2 parameter File path and filename and pass this as expression in the connection manager so that at runtime it dynamically pick the path and file name.
谢谢
Dilip
这篇关于Excel连接始终在通过Job运行时查找文件模板的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!