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

Posted on 2011-05-05
Last Modified: 2013-11-30
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!


Question by:mattPlymouth
    LVL 21

    Expert Comment

    by:Alpesh Patel
    please check the task

    Author Comment

    What do you mean by check the task?
    LVL 21

    Accepted Solution

    Try to run it from BIDS, set a checkpoint and watch for the variable when it changes, and try to troubleshoot that.

    once I've followed this article when I was implementing that.

    That's the only thing I can think of!

    LVL 21

    Expert Comment


    Any luck? need more info?

    Jason Yousef
    LVL 31

    Expert Comment

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

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
    I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
    The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now