Execute Process Task: Issues encrypting text file using PGP in SSIS 2022

  • Hello SSC,

    Has anyone encountered this before???

    I have an odd issue that I need to debug. I am encrypting a text file to PGP. I am able to do this locally without any issues, but when I try to transfer the file to the SFTP site, it fails. I Googled this issue and actually watched a bunch of videos on file encryption, and it looks like I am doing this correctly. Code sample and the response from the recipient is below.

    Any assistance would be greatly appreciated!

    Execute Process Task:

    Executable: C:\blah\blah\bin\gpg.exe

    Arguments: --output Somefile.txt.gpg --encrypt --recipient Somewhere@Someplace.com Somefile.txt

    "Non-UTF8 characters aren’t accepted and can cause issues during the file load process. I noticed your file contains non-UTF8 characters in multiple rows. When opened in Notepad++, these lines typically look like the example below. Error loading client records. File received contained over 90 percent invalid records."

    encryption_issue

     

     

     

     

    The are no problems, only solutions. --John Lennon

Viewing post 1 (of 1 total)

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