Other than thanking me, your post appears to have ignored mine.

Please describe why the idea I suggested is not applicable in your case.

Okay, this is VERY weird. My last post, when I hit submit, errored out with "Are you sure you want to do that?"

And when I hit submit again, it...

Perhaps this example explains what is happening?

SELECT AVG(x.n)
FROM (VALUES (1), (2), (3), (5)) x (n);

SELECT AVG(CAST(x.n AS DECIMAL(19, 6)))
FROM (VALUES (1), (2), (3), (5)) x (n);

I've read through your code a couple of times and I'm still not sure exactly what it is doing, but I can offer some input.

You appear to be building a...

I cannot see a question here.

The problem is that I can’t seem to find the menu this person is referring to.  Can anyone else give any extra information on this?  Ideally with screenshots?

The link you...

Product.ProductDetails is what you should be including in your query. Including database name is usually a bad idea (if you ever rename the database, the query will no longer return...

All tables in SQL Server belong to a schema. What problem are they causing you?

OK, in my opinion, the problem does not lie with OPENJSON. The following is valid JSON:

{
  "Produtos": [
    {
    ...

Can you provide some literal sample content for @json, please. For many people, sp_OACreate and other OA modules are blocked for security reasons.

This chunk of C# is sufficiently complex that I doubt anyone here will produce a modified version for you. But I will provide some comments:

1. It seems obvious, but why...

I used to use the Azure SSIS Integration Runtime, but stopped using it because of some limitations (it was expensive too). It was more than a year ago, so I...

This thread is about the SSIS/SSAS/SSRS extensions for VS 2022, not SSDT itself. Those extensions do not yet seem to be available. Eg,...

When I do things like this, I return separate columns for the properties I wish to control (font, bold, colour etc) and then assign those columns to the...

I was half looking forward to giving this a proper go, as I'm sure it would be good for my own PQ education, but it seems that it's probably not...