UTF-8-safe argument

--output Somefile.txt.gpg

--encrypt

--recipient Somewhere@Someplace.com

--utf8-strings

Somefile.txt

You should be sending the file ending in .gpg

Which File  are you sending? Somefile.txt.gpg  or  Somefile.txt, you should be sending the Somefile.txt.gpg

Yes but in your Argument your sending the unencrypted file.  Somefile.txt

FYI: in your Argument your sending the unencrypted file.  Shouldn't you be sending the  Somefile.txt.gpg file instead?

Execute Process Task:

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

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

• This reply was modified 2 weeks, 2 days ago by Tav29.

You can try running this PS Script on the text file before encrypting it.

(Get-Content "C:\path\file.txt") |
    Set-Content -Encoding UTF8 "C:\path\file_utf8.txt"

1. is SSIS calling a Powershell Script that moves the file to SFTP?
2. SSIS only supports FTP/FTPS not SFTP

• This reply was modified 2 weeks, 2 days ago by Tav29.

GnuPG = gpg.exe

Is SSRS giving you an error message? If so, screenshot please. Try updating the DataSource on ssrs for the failed report.

• This reply was modified 2 months, 3 weeks ago by Tav29.

Are you referring to this?

Add TrustServerCertificate=True; to the connection string.

hmmmm.....

ISNULL(
    SUM(
        CASE 
            WHEN colB...

you ran this?

ISNULL(

SUM(

colA * Constant1 * colC /

(NULLIF(colB, 0) * CASE WHEN colD = 'XX' THEN Constant2 ELSE 1 END)

), 0

) AS calcdfield

Are you making any calculations in the report?