Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
InicianteSQL
Starting Member
2 Posts |
 Posted - 2012-01-27 : 13:22:50
|
| Hi Experts,I have a process in SSIS that have a function to encrypt a zipfile. I'm using PGP command line inside a .bat file. Using DTEXEC (Cmd), SSMS (Job) and SSIS (Debug Mode) I have the same error below:DTEXEC.EXE /F "E:\MyApplication\App\bin\MyApplication.dtsx"[Execute Process Task] Error: In Executing "C:\MyApplication\Applications\PGP.bat" "" at "E:\MyApplication", The process exit code was "2" while the expected was "0".I already verify all paths in my environment, the executable is in the path, I'm tre administrator of the machine but the thing isn't working.Follow above the code of PGP:gpg --recipient "MyApp" --output "Encrypted.ZIP.PGP" --encrypt "Encrypted.ZIP"Thanks in advance. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-27 : 15:24:58
|
| 1. Are you able to encrypt outside of the SSIS task?2. The PGP key ring may be specific to each user, so verify that the user who is running the SSIS task has the keyring.3. The very first time your run pgp on box, it prompts you to accept a license agreement, so if you have never run pgp on that box, run it from a command window and accept the license agreement. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-27 : 17:39:07
|
| did you running bat itself outside SSIS and see if its working fine?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
PGP Problems in SSIS