<div>
What do you mean by check the task?
</div>


<div>
Hi,<br />
<br />
Any luck? need more info?<br />
<br />
Regards,<br />
Jason Yousef<br />

</div>


Hi,

Any luck? need more info?

Regards,
Jason Yousef


<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I have an Execute Process task within a SSIS Package, where I am executing gpg.exe.<br />
<br />
My StandardInputVariable is <b>User::Passphrase</b> (which contains my Passphrase)<br />
<br />
My Arguments string is as follows:<br />
<b>--passphrase-fd 0 --output &quot;C:\...OutputFilePath&quot; --yes --decrypt &quot;C:\...FileToDecryptPath&quot;</b><br />
<br />
At one point everything was working fine, however now I'm getting prompted by GPG to enter my Passphrase, even though I'm passing it in. This happens if I run the Package locally, or run it scheduled as a SQL Job.<br />
<br />
I'm going crazy here trying to figure this out, any help would be greatly appreciated. Thanks!<br />
<br />
Matt<br />
<br />

</div>
</div>


I have an Execute Process task within a SSIS Package, where I am executing gpg.exe.

My StandardInputVariable is User::Passphrase (which contains my Passphrase)

My Arguments string is as follows:
--passphrase-fd 0 --output "C:\...OutputFilePath" --yes --decrypt "C:\...FileToDecryptPath"

At one point everything was working fine, however now I'm getting prompted by GPG to enter my Passphrase, even though I'm passing it in. This happens if I run the Package locally, or run it scheduled as a SQL Job.

I'm going crazy here trying to figure this out, any help would be greatly appreciated. Thanks!

Matt



GPG decryption in SSIS Execute Process - prompting for Passphrase even though I'm passing it in

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.