thank you very much!

It does not help though. I need to have a SSIS annotation. How can I use BIML to generate packages when I cannot add a simple...

Is there a way to add Annotation to the package? Like when you right click and select "Add Annotation" ?

It is very useful.

It showed statistics as duplicate indexes though.

the spatial query is performed on the base table, not the temp table but it inserts the results into a temp table

I am sure the spatial index is being used...

thank you!

It is faster than a cursor and it's simpler to implement. The cursor processes one row at a time.

using a quirky update in a function - what do you...

Thank you 🙂 ! I will definitely try FOR XML PATH. I came up with the recursive CTE solution after reading about another application of recursive CTEs, but perhaps performance...