If you change the protection level to Don't Save Sensitive and try deploying again, the error should go away.

However, the values of any params marked as sensitive will not be...

In VS2022, if you go to Extensions/Installed/All, do you see the following?

'SQL Server Integration Services Projects 2022'

Can you provide the exact error message?

What is the Protection Level of the SSIS project? (Under Project/Properties)

Please expand your sample data to include some values with embedded commas, so that I can assess whether the existing code can be refined to handle them. Thank you.

Note that...

Thanks.  This looks good.  Haddnt stumbled on split_string

When i run code on my machine it returns?

Msg 8144, Level 16, State 3, Line 27 Procedure or function string_split has too...

... future? 😀

The stored proc GetSOR_Abstract is specific to your environment, so we can't help in detail.

But it looks like @tempdata is defined with a maximum length of 128 within the definition...

Like this?

SELECT t.n_type
      ,Total = COUNT (1)
      ,a_type = COUNT (IIF(t.d_type = 'a_type', 1, NULL))
  ...

• This reply was modified 1 years, 10 months ago by Phil Parkin.

Do you have any control over the format of the input file? If you could get them to use a delimiter which will not appear elsewhere in the text (|...

DelimitedSplit8k is a highly optimised string splitter that was written in the days when there was nothing comparable built in to T-SQL. It has since become the de facto standard...

• This reply was modified 1 years, 10 months ago by Phil Parkin.

Would you please provide your sample data in the form of CREATE TABLE / INSERT statements?

Try this, maybe?

https://www.sqlservercentral.com/scripts/patexclude8k

If len(string) > len(processed string)

you know that 'string' contained 'invalid' characters.

• This reply was modified 1 years, 10 months ago by Phil Parkin.

If you are hoping for a dynamic solution which does not require you to type in the names of each key, that takes quite a chunk of coding and requires...

This looks like it would work:

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-configure-power-bi-report-server-catalog?view=sql-server-ver16

OK, I don't know. Can't see anything obvious.