Thank you but I didn't find the code of fnTally on the link.

I also didn't understand how to use log/exp functions to solve this task.

• This reply was modified 4 months ago by  us26.

Thank you for help!

Now I see clearly that recursive cte should be used here to support unknown number of parts in each group without changing the code.

.. restoring SSISDB incorrectly ..

Hm.. Interestingly, I recently restored SSISDB from backup taken from another SQL Server (production server) .

Is it wrong?

To be clear, you had to rebuild the missing "##MS_SSISServerCleanupJobUser##" login or was there something else?

I'm not sure what statement fixed the issue but all the steps from that article...

This fixed the issue:

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-upgrade-failed-error-15151

Thanks.

I wonder would it be possible to use SQL Profiler (or XE) to find out this kind of issues?

To detect the batch (statement) failed during...

Thanks for your solution!

Looks awesome.

The only one disadvantage is necessity to give names to columns manually.

Is there any way to do it automatically?

Preferably without dynamic-sql.

If you need it, I...

• This reply was modified 1 year, 2 months ago by  us26.