Decrypting a PGP file with Execute process task

Question

Decrypting a PGP file with Execute process task

praneethus

SSC-Addicted

Points: 481
More actions
January 28, 2010 at 6:52 am

#140916

I have a scenario to decrypt a PGP file and I am doing with Execute process task, my pgp.exe, my decrypting files are in the same folder. please find Execute process task setup below.
Executables: C:\SSIS\gpg.exe
Arguments:--passphrase-fd 0 --decrypt-files c:\SSIS\test02.txt.pgp
working directory: C:\SSIS
my passphrase file is coming from Input variable
I can decrypt the file using command prompt, but in SSIS its not working and I getting following error.
[Execute Process Task] Error: In Executing "C:\SSIS\gpg.exe" "--passphrase-fd 0 --decrypt-files C:\SSIS\test02.txt.pgp" at "C:\ssis", The process exit code was "2" while the expected was "0".
can you please help me out in resolving the problem , as I need to deliver it to day.
Thanks in advance!!!!!
Praneeth

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

If you can use third-party solutions, check the commercial CozyRoc OpenPGP Task. It is completely integrated in SSIS and easier to use.

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

msumangupta Old Hand Points: 359 More actions · Answer 2

Hi

I encrypted a text file using OPENpgp Task provided by CozyRoc.

When the other end of the line is trying to decrypt it, they receive a error saying that,

ERROR:

Decompressed

faile:/<FILEPATH>

for a test, I created a sample test file. and encrypted the file with the condition OldFormat setting to True and False in SQL 2005 and 2008. they were able to decrypt all the 4 files.

But when we are trying to send a file that was created after the execution of the package, they are not able to decrypt the file.

Any suggestions are appreciated

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

msumangupta (2/19/2010)
Hi
I encrypted a text file using OPENpgp Task provided by CozyRoc.
When the other end of the line is trying to decrypt it, they receive a error saying that,
ERROR:
Decompressed
faile:/<FILEPATH>
for a test, I created a sample test file. and encrypted the file with the condition OldFormat setting to True and False in SQL 2005 and 2008. they were able to decrypt all the 4 files.
But when we are trying to send a file that was created after the execution of the package, they are not able to decrypt the file.
Any suggestions are appreciated

How do you send the files? Do you use SSH Connection Manager?

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

msumangupta Old Hand Points: 359 More actions · Answer 4

We put the files in a FTP Server.

They just grab the files from there.

COZYROC One Orange Chip Points: 28499 More actions · Answer 5

msumangupta (2/19/2010)
We put the files in a FTP Server.
They just grab the files from there.

I understand this. But what connection manager do you use to transfer the files?

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

msumangupta Old Hand Points: 359 More actions · Answer 6

We use FTP Conncetion Manager.

We are not using the SFTP Task.

COZYROC One Orange Chip Points: 28499 More actions · Answer 7

msumangupta (2/19/2010)
We use FTP Conncetion Manager.
We are not using the SFTP Task.

Have you tried to decrypt the file locally before sending to the remote location? Did it work? Also what version of SSIS+ do you use?

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

msumangupta Old Hand Points: 359 More actions · Answer 8

We donot have the Key to decrypt the file.

We use SQL Server 2008 and Cozyroc+1.3

msumangupta Old Hand Points: 359 More actions · Answer 9

WE use CozyRoc SSIS+1.3 for SQL 2005

and CozyRoc SSIS+1.4 for SQL 2008

COZYROC One Orange Chip Points: 28499 More actions · Answer 10

msumangupta (2/19/2010)
WE use CozyRoc SSIS+1.3 for SQL 2005
and CozyRoc SSIS+1.4 for SQL 2008

Can you try to deliver the file as a test using other method like email? My point is to find out if the issue is due to the encryption or the issue is caused during transportation of the file.

Also can you ask your party what is the exact error they are getting and what is the decryption software and version in use.

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

athmaram_p SSC Enthusiast Points: 105 More actions · Answer 11

Hi Praneet,

Even i am working on similar kind of task. So, if your question is resolved? can you please help me in the steps for PGP decryption using SSIS.

Thanks

Ram