gpg.exe未解密sql作业中ssis包中的文件 [英] gpg.exe is not decrypting file in ssis package in the sql job

问题描述

我在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

推荐答案

最后，我找到了解决方案，程序包或作业中没有错误.这只是一个安全问题，不允许执行包含可执行文件的作业.我所做的我已经在sql服务器配置管理器>> SQL服务器代理中添加了当前用户详细信息.代替内置帐户，请检查此帐户"，然后输入当前帐户详细信息.

Finally i found the solution, There is no error in the package or job. It was only a security issue which was not allowing to execute a job containing executable file. What i did that i have added the current user detail in sql server configuration manager>>SQL server agent. Instead of Built in account check the This account and enter the current account detail.

这篇关于gpg.exe未解密sql作业中ssis包中的文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！