January 24, 2009 at 12:13 pm
Hi,
I have one zip file on remote server (e.g. A). I can able to build PGP file by using command line localy onto that server. But I need to make one SSIS Package, which runs from another server (e.g. B). I am using Execute process task to make pgp on server A. But when i am doing this thing, nothing will happen and the task execute with the error.
I am selecting PGP.exe in Executable option. And in argument option i just write down
-e file1.zip security_key
and also setting the workind directory option with that folder where my file1.zip is stored.
I don't know whats the problem there, because same command is successfully complete on Server A locally. But calling from remote Server B, it might create some kind of security issue and that is the reason why task is failing - this is my guess but i am not sure.
Is anyone has any suggestion or idea, which solves my problem?
Thank you
January 25, 2009 at 10:33 am
It's not really clear what the error or issue is. Whatever you do with PGP, you should be able to do with the command line. Once you can execute things from the command line on both servers, then you can transfer that to SSIS.
If you are getting a specific error, please post it.
January 26, 2009 at 4:28 am
Hi,
Thanks for the reply. Following is my exact error :
SSIS package "xyz.dtsx" starting.
Error: 0xC0029151 at Make encrypted Zip file using PGP, Execute Process Task: In Executing "\\1.1.1.2\PGP_Folder\PGP.exe" "-e abc.zip Security_Key" at "\\1.1.1.2\abc_RootFolder\abc_Actualfolder", The process exit code was "21" while the expected was "0".
Task failed: Make encrypted Zip file using PGP
Warning: 0x80019002 at xyz extract: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "xyz.dtsx" finished: Failure.
the file name and remote IP is changed here.
If you need any further information please post your question here.
Thank you
January 28, 2009 at 3:51 am
Hi all,
Good news, I've solved my problem....
One thing that we all need to notice is when we pass the "\" character in the argument as part of to represent the actual path of the file, ssis will mis interprete this things. So, use expression to write your arguments. and wherever you need to place a single \ (backslash), you need to put two.
for e.g
\\1.1.1.1\abc\xyz.txt instead of this you need to write down an expression
"\\\\1.1.1.1\\abc\\xyz.txt"
I hope this will solve our problem in many cases......
Enjoy...
Cheers....
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply