Problems Decrypting PGP files with SSIS

• mrtrich99

  SSCrazy

  Points: 2000

  More actions

  October 8, 2008 at 6:06 pm

  #124092

  I have a dtsx package that will decrypt a bunch of PGP files. The package works perfectly if I use Microsoft Visual Studio by using the play ("start debugging") button but when I use a batch file or double click on the package and use the execute button to run the package the package errors out because "The process exit code was 2 while the expected was 0". The exit code is in my "Execute Process Task Editor" in the SuccessValue of the Process section. If I change this to 2 the file still doesn't get decrypted but my other task of moving the encrypted files to another location does get execute.

  Does anybody have any idea as to why the decryption works when I use Visual Studio and not when it's outside of Visual Studio?

  Thanks.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  October 24, 2008 at 5:10 pm

  #889558

  Check PGP Task. It has very simple UI and great integration in SSIS.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/