Hello Kaj,

Thank you for your response. I am using SQL version 2022 and VS version 2026. The package was written in SQL version 2016. (Perhaps I need to upgrade the...

Please ignore/delete this post, it is a duplicate. Apologies for the inconvenience.

Please ignore/delete this post, it is a duplicate. Apologies for the inconvenience.

Hi Ross,

I never heard of Ascii armor before. Thank you for the knowledge share!

Dave

We are sending the ". GPG" file. We are checking with the client; we believe the issue is on their end. They claim the files is 90% invalid characters. This...

I will try that, thank you very much for your time. Thanks to Phil as well.

You folks have a great long weekend!

So, you are saying that the txt and txt.gpg should be reversed? I am not saying that you are wrong, but I Googled this and watched a few videos on...

The file is being rejected due to Non-UTF8 characters by the client. I am able to encrypt it locally. If the output was a text file, I would think the...

Isn't this the output?

--output Somefile.txt.gpg

The error message is coming from the company which we are sending the encrypted file to. Just to be clear, this file is being rejected from the client's side. On...

Hi Phil,

Happy new year!

That is the executable for the software that encrypts the file. I think...

Thanks Lowell! This script is awesome! Just what I needed for analysis!

Hi Scott,

Nice to hear from you as always. hope you are doing well.

I would love some code if you would be so kind to share it with me.

Dave

Hi Phil,

Thank you for responding as always. Long story short, I raised this issue with a senior developer on my team that understands the process. I will update this post...

We are going to try SQLXML 4.0. It seems to be what we need. We have one master stored procedure that is calling 15 child procs that all have dynamic...