问题描述
我在SSIS包的控制流中插入了一个执行过程任务，该任务从文件夹中获取加密文件并使用gpg.exe解密文件.我已经将密钥以及密码短语传递到了执行流程任务的表达式中.直接运行程序包时，它将成功执行并解密文件.但是，当我在该程序包的sql server 2005中创建作业并执行该作业时，它显示已成功执行，但没有文件被转换.
任何建议出了什么问题或作业中存在任何其他安全问题
I have inserted an execute process task in the control flow of the SSIS package which gets encrypted files from a folder and decrypts file using the gpg.exe. I have passed the key as well as passphrase in to the expression of the execute process task. while running the package directly it executes successfully and also decrypts the file. But, when i create a job in the sql server 2005 of that package and execute the job, it shows successfully executed but neither of the file is being converted.
Any suggestion what is going wrong or any other security issues is existing in the job
推荐答案
这篇关于gpg.exe未解密sql作业中ssis包中的文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！