When you run the script task, you should be able to step through the code, line by line (you only need one breakpoint at the start to make this process...

Run the script in debug mode to determine the line which causes the error and to dig deeper into the details of the error.

• This reply was modified 4 days, 11 hours ago by Phil Parkin.

So ... you're using PGP and the executable is called GPG ... weird, but OK!

If that is just the encryption process, what is doing the SFTP part which is when...

How will the data be used, other than for INSERTs?

What does gpg.exe do?

Perhaps the word 'DevOps' has confused things here? I'm assuming you're talking about 'Azure DevOps' specifically, and not DevOps is general?

Azure DevOps can be used for several things, including task...

Thank you for the response, Steve.

I have tracked down the problem – for testing purposes, a database restore had been performed, from a database with CT enabled. Nothing was consuming...

Hi Steve, sorry for the slow reply.

One of the database sources is SQL Server 2022, CU22, with DB at compatibility level 100.

Another is an Azure SQL database which is running...

Sure there is. In your Excel source, define a suitable sheet name and range, eg

Sheet1$A1:H21

I wish you'd asked me at the time, as my medium-term memory only works for a few hours these days!

What I think happened was I tried to create a detailed...

Is that this Dev Express?

https://docs.devexpress.com/WindowsForms/2141/common-features/formatting-values/format-specifiers

It seems to have a comprehensive formatting capability.

As I am running exactly the same version of SQL Server as you, I can only conclude that your query settings must somehow be affecting the result. Not sure I...

This is the code I ran. Can you confirm that it produces inconsistent results on your system?

SELECT @@VERSION
 
SELECT '1.' Id
UNION ALL
SELECT '1-' Id
ORDER BY Id
 
SELECT...

Interestingly, using only VARCHAR produces consistent results. Not sure why Unicode characters are working differently.

My e-mail notifications (except for the newsletter) stopped working at the end of June. But it seems the problem is resolved now.